View: OKL_K_HDR_CRDTLN_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for creditline list of values for a lease contract.
Implementation/DBA Data:	APPS.OKL_K_HDR_CRDTLN_UV

View Text

SELECT CHR.ID ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRT.DESCRIPTION DESCRIPTION
, CHR.SCS_CODE SCS_CODE
, CHR.CURRENCY_CODE CURRENCY_CODE
, CHR.STS_CODE STS_CODE
, CHR.TEMPLATE_YN TEMPLATE_YN
, CHR.BUY_OR_SELL BUY_OR_SELL
, CHR.START_DATE START_DATE
, CHR.END_DATE END_DATE
, KHR.REVOLVING_CREDIT_YN REVOLVING_CREDIT_YN
, RLE.OBJECT1_ID1 CUST_OBJECT1_ID1
, RLE.OBJECT1_ID2 CUST_OBJECT1_ID2
, RLE.JTOT_OBJECT1_CODE CUST_JTOT_OBJECT1_CODE
, HZ_P.PARTY_NAME CUST_NAME
, HZ_CA.ACCOUNT_NUMBER CUST_ACC_NUMBER
FROM OKC_K_HEADERS_B CHR
, OKC_K_HEADERS_TL CHRT
, OKL_K_HEADERS KHR
, OKC_K_PARTY_ROLES_B RLE
, HZ_PARTIES HZ_P
, HZ_CUST_ACCOUNTS HZ_CA
WHERE CHR.ID = KHR.ID
AND CHR.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND CHR.ID = RLE.DNZ_CHR_ID
AND CHR.ID = RLE.CHR_ID
AND RLE.RLE_CODE = 'LESSEE'
AND CHR.SCS_CODE = 'CREDITLINE_CONTRACT'
AND CHR.STS_CODE = 'ACTIVE'
AND CHR.TEMPLATE_YN = 'N'
AND CHR.BUY_OR_SELL = 'S'
AND RLE.OBJECT1_ID1 = HZ_P.PARTY_ID
AND RLE.OBJECT1_ID2 = '#'
AND HZ_P.PARTY_TYPE IN ( 'PERSON'
, 'ORGANIZATION')
AND HZ_CA.PARTY_ID = HZ_P.PARTY_ID
AND CHR.CUST_ACCT_ID = HZ_CA.CUST_ACCOUNT_ID

Columns