View: OKL_CREDITLINES_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for Credit Line Contract Page
Implementation/DBA Data:	APPS.OKL_CREDITLINES_UV

View Text

SELECT CHRB.ID ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRT.DESCRIPTION DESCRIPTION
, CHRB.STS_CODE STS_CODE
, STATUS.MEANING STS_MEANING
, CHRB.SCS_CODE SCS_CODE
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CURR.NAME CURRENCY_NAME
, KHR.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, DCT.USER_CONVERSION_TYPE USER_CONVERSION_TYPE
, KHR.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, KHR.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, KHR.REVOLVING_CREDIT_YN REVOLVING_CREDIT_YN
, CPL.ID PARTY_ROLES_ID
, CPL.OBJECT1_ID1 CUSTOMER_ID1
, CPL.OBJECT1_ID2 CUSTOMER_ID2
, PARTY.NAME CUSTOMER_NAME
, PARTY.DESCRIPTION CUSTOMER_NUMBER
, CPL.JTOT_OBJECT1_CODE CUSTOMER_JTOT_OBJECT_CODE
, CHRB.CUST_ACCT_ID CUST_ACCT_ID
, CUST_ACCT.NAME CUST_ACCT_NAME
, CUST_ACCT.DESCRIPTION CUST_ACCT_NUMBER
, NVL(SITE.DESCRIPTION
, ' ') LEGAL_ADDRESS
, RUL.RGP_ID CHKLST_TPL_RGP_ID
, RUL.ID CHKLST_TPL_RULE_ID
, RUL.RULE_INFORMATION1 CREDITLINE_CKL_ID
, (SELECT CHECKLIST_NUMBER
FROM OKL_CHECKLISTS CKL
WHERE TO_CHAR(CKL.ID) = RUL.RULE_INFORMATION1) CREDITLINE_CKL_NUMBER
, RUL.RULE_INFORMATION2 FUNDING_CKL_ID
, (SELECT CHECKLIST_NUMBER
FROM OKL_CHECKLISTS CKL
WHERE TO_CHAR(CKL.ID) = RUL.RULE_INFORMATION2) FUNDING_CKL_NUMBER
, NVL(OKL_SEEDED_FUNCTIONS_PVT.CREDITLINE_TOTAL_LIMIT(CHRB.ID)
, 0) TOTAL_LIMIT
, NVL(OKL_SEEDED_FUNCTIONS_PVT.CREDITLINE_TOTAL_REMAINING(CHRB.ID)
, 0) REMAINING
FROM OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
, OKL_K_HEADERS KHR
, OKX_CUSTOMER_ACCOUNTS_V CUST_ACCT
, OKC_RULES_B RUL
, OKX_PARTIES_V PARTY
, OKC_K_PARTY_ROLES_B CPL
, OKX_CUST_SITE_USES_V SITE
, OKC_STATUSES_V STATUS
, FND_CURRENCIES_VL CURR
, GL_DAILY_CONVERSION_TYPES_V DCT
WHERE CHRB.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND CHRB.ID = KHR.ID
AND CHRB.SCS_CODE = 'CREDITLINE_CONTRACT'
AND CUST_ACCT.ID1(+) = CHRB.CUST_ACCT_ID
AND CUST_ACCT.ID2(+) = '#'
AND RUL.RULE_INFORMATION_CATEGORY(+) = 'LACCLT'
AND RUL.DNZ_CHR_ID(+) = CHRB.ID
AND PARTY.ID1 = CPL.OBJECT1_ID1
AND PARTY.ID2 = CPL.OBJECT1_ID2
AND CPL.RLE_CODE = 'LESSEE'
AND CPL.CHR_ID = CHRB.ID
AND SITE.SITE_USE_CODE(+) = 'LEGAL'
AND SITE.CUST_ACCOUNT_ID(+) = CUST_ACCT.ID1
AND CHRB.STS_CODE = STATUS.CODE
AND CHRB.CURRENCY_CODE = CURR.CURRENCY_CODE
AND DCT.CONVERSION_TYPE(+) = KHR.CURRENCY_CONVERSION_TYPE

Columns