1 query found for "UOM Language"
Billing History (UOM/TOU/SQI) for Service Agreement
SELECT DISTINCT B.UOM_CD, B.TOU_CD, B.SQI_CD
, C.DESCR AS UOM_DESCR, D.DESCR AS TOU_DESCR, E.DESCR AS SQI_DESCR
FROM CI_BSEG A
,CI_BSEG_SQ B
,CI_UOM_L C
,CI_TOU_L D
,CI_SQI_L E
WHERE A.SA_ID = 'INSERT_SERVICE_AGREEMENT_ID'
AND A.BSEG_ID = B.BSEG_ID
AND (B.UOM_CD = C.UOM_CD (+) AND C.LANGUAGE_CD (+) = 'INSERT_LANGUAGE_CD_MOSTLY_ENG')
AND (B.TOU_CD = D.TOU_CD (+) AND D.LANGUAGE_CD (+) = 'INSERT_LANGUAGE_CD_MOSTLY_ENG')
AND (B.SQI_CD = E.SQI_CD (+) AND E.LANGUAGE_CD (+) = 'INSERT_LANGUAGE_CD_MOSTLY_ENG')
uploaded by Nuno Rodrigues