View: OKL_BPD_TLD_AR_LINES_V

Product:	OKL - Lease and Finance Management
Description:	View on TLD and receivables lines for variable rate and bill status API and remarketing view.
Implementation/DBA Data:	APPS.OKL_BPD_TLD_AR_LINES_V

View Text

SELECT TLD.ID TLD_ID
, TLD.KHR_ID KHR_ID
, TLD.STY_ID STY_ID
, RACTRL.INTERFACE_LINE_ATTRIBUTE6 CONTRACT_NUMBER
, RACTRL.INTERFACE_LINE_ATTRIBUTE9 STREAM_TYPE
, RACTRL.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, RACTRL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, TIL.KLE_ID KLE_ID
, TAI.TRX_STATUS_CODE TRX_STATUS_CODE
, TAI.DATE_INVOICED INVOICE_DATE
, TLD.SEL_ID SEL_ID
, TLD.TIL_ID_DETAILS TIL_ID_DETAILS
, TAI_TL.DESCRIPTION DESCRIPTION
, TAI.DATE_INVOICED DATE_INVOICED
, TAI.AMOUNT AMOUNT
, /*--(RACTRL.QUANTITY_INVOICED * RACTRL.UNIT_SELLING_PRICE) LINE_AMOUNT
, */ /* NULL TAX_AMOUNT
, */ (SELECT SUM(NVL(EXTENDED_AMOUNT
, 0))
FROM RA_CUSTOMER_TRX_LINES_ALL
WHERE LINK_TO_CUST_TRX_LINE_ID = RACTRL.CUSTOMER_TRX_LINE_ID
AND LINE_TYPE='TAX' ) TAX_AMOUNT
, TIL.ISL_ID ISL_ID
, TAI.IBT_ID IBT_ID
, TAI.DATE_ENTERED DATE_ENTERED
, RACTRL.INTERFACE_LINE_ATTRIBUTE1 CONSOLIDATED_INVOICE_NUMBER
, /*-- ASSUME 1 IS CONS INV NO*/ RACTRL.EXTENDED_AMOUNT LINE_AMOUNT
, /* RACTRL.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, RACTRL.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL */ OKL_BILLING_UTIL_PVT.INVOICE_LINE_AMOUNT_REMAINING(RACTRL.CUSTOMER_TRX_ID
, RACTRL.CUSTOMER_TRX_LINE_ID) AMOUNT_DUE_REMAINING
, OKL_BILLING_UTIL_PVT.INVOICE_LINE_AMOUNT_ORIG(RACTRL.CUSTOMER_TRX_ID
, RACTRL.CUSTOMER_TRX_LINE_ID) AMOUNT_DUE_ORIGINAL
FROM OKL_TXD_AR_LN_DTLS_B TLD
, RA_CUSTOMER_TRX_LINES_ALL RACTRL
, OKL_TXL_AR_INV_LNS_B TIL
, OKL_TRX_AR_INVOICES_B TAI
, OKL_TRX_AR_INVOICES_TL TAI_TL
WHERE TO_CHAR(TLD.ID) = RACTRL.INTERFACE_LINE_ATTRIBUTE14 /*-- ASSUME 14 HAS TLD ID*/
AND TLD.TIL_ID_DETAILS = TIL.ID
AND TIL.TAI_ID = TAI.ID
AND TAI.ID = TAI_TL.ID
AND TAI_TL.LANGUAGE = USERENV('LANG')

Columns