eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_CONDTLS_WELCOME_UV

Source

View Text - Preformatted


SELECT CHRB.ID ID ,CHRB.INV_ORGANIZATION_ID INV_ORGANIZATION_ID ,CHRB.STS_CODE STS_CODE ,CHRB.QCL_ID QCL_ID ,CHRB.SCS_CODE SCS_CODE ,CHRB.CONTRACT_NUMBER CONTRACT_NUMBER ,CHRB.CURRENCY_CODE CURRENCY_CODE ,CHRB.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER ,CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION ,CHRT.COMMENTS COMMENTS ,CHRT.DESCRIPTION DESCRIPTION ,CHRB.DATE_APPROVED DATE_APPROVED ,CHRB.DATE_ISSUED DATE_ISSUED ,CHRB.START_DATE START_DATE ,CHRB.END_DATE END_DATE ,CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID ,KHR.KHR_ID KHR_ID ,KHR.PDT_ID PDT_ID ,HP.PARTY_NAME CUSTOMER_NAME ,OST.MEANING CONTRACT_STATUS ,OP.NAME PRDUCT_NAME FROM OKC_K_HEADERS_B CHRB,OKL_K_HEADERS KHR,OKC_K_HEADERS_TL CHRT,OKL_PRODUCTS OP,OKC_STATUSES_TL OST,OKC_RULES_B ORGB1,OKC_RULE_GROUPS_B ORGB2,HZ_CUST_ACCOUNTS HCA,HZ_PARTIES HP WHERE CHRB.ID = CHRT.ID AND CHRB.START_DATE IS NOT NULL AND CHRT.LANGUAGE = USERENV('LANG') AND KHR.ID = CHRB.ID AND OP.ID(+) = KHR.PDT_ID AND CHRB.STS_CODE = OST.CODE AND OST.LANGUAGE = USERENV('LANG') AND ORGB2.ID = ORGB1.RGP_ID AND HCA.PARTY_ID = HP.PARTY_ID AND HCA.CUST_ACCOUNT_ID = ORGB1.OBJECT1_ID1 AND CHRB.ID = ORGB1.DNZ_CHR_ID AND CHRB.ID = ORGB2.CHR_ID AND ORGB1.RULE_INFORMATION_CATEGORY = 'CAN' AND ORGB2.RGD_CODE = 'LACAN' ORDER BY START_DATE DESC

View Text - HTML Formatted

SELECT CHRB.ID ID
, CHRB.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, CHRB.STS_CODE STS_CODE
, CHRB.QCL_ID QCL_ID
, CHRB.SCS_CODE SCS_CODE
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRT.COMMENTS COMMENTS
, CHRT.DESCRIPTION DESCRIPTION
, CHRB.DATE_APPROVED DATE_APPROVED
, CHRB.DATE_ISSUED DATE_ISSUED
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, KHR.KHR_ID KHR_ID
, KHR.PDT_ID PDT_ID
, HP.PARTY_NAME CUSTOMER_NAME
, OST.MEANING CONTRACT_STATUS
, OP.NAME PRDUCT_NAME
FROM OKC_K_HEADERS_B CHRB
, OKL_K_HEADERS KHR
, OKC_K_HEADERS_TL CHRT
, OKL_PRODUCTS OP
, OKC_STATUSES_TL OST
, OKC_RULES_B ORGB1
, OKC_RULE_GROUPS_B ORGB2
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
WHERE CHRB.ID = CHRT.ID
AND CHRB.START_DATE IS NOT NULL
AND CHRT.LANGUAGE = USERENV('LANG')
AND KHR.ID = CHRB.ID
AND OP.ID(+) = KHR.PDT_ID
AND CHRB.STS_CODE = OST.CODE
AND OST.LANGUAGE = USERENV('LANG')
AND ORGB2.ID = ORGB1.RGP_ID
AND HCA.PARTY_ID = HP.PARTY_ID
AND HCA.CUST_ACCOUNT_ID = ORGB1.OBJECT1_ID1
AND CHRB.ID = ORGB1.DNZ_CHR_ID
AND CHRB.ID = ORGB2.CHR_ID
AND ORGB1.RULE_INFORMATION_CATEGORY = 'CAN'
AND ORGB2.RGD_CODE = 'LACAN' ORDER BY START_DATE DESC