View: OKL_CONDTLS_WELCOME_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CONDTLS_WELCOME_UV

View Text

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

Columns