View: OKL_BPD_AR_INV_LINES_V

Product:	OKL - Leasing and Finance Management
Description:	View to display Payable Invoice Line details.
Implementation/DBA Data:	APPS.OKL_BPD_AR_INV_LINES_V

View Text

SELECT RACTRL.INTERFACE_LINE_ATTRIBUTE6 CONTRACT_NUMBER
, TXD.KHR_ID CONTRACT_ID
, TIL.KLE_ID CONTRACT_LINE_ID
, RACTRX.TRX_NUMBER RECEIVABLES_INVOICE_NUMBER
, RACTRX.CUSTOMER_TRX_ID RECEIVABLES_INVOICE_ID
, RACTRX.CUSTOMER_TRX_ID INVOICE_ID
, TXD.ID TXD_ID
, TXD.ID STREAM_ID
, /* RACTRL.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, */ OKL_BILLING_UTIL_PVT.INVOICE_LINE_AMOUNT_REMAINING(RACTRX.CUSTOMER_TRX_ID
, RACTRL.CUSTOMER_TRX_LINE_ID) AMOUNT_DUE_REMAINING
, /*RACTRL.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, */ OKL_BILLING_UTIL_PVT.INVOICE_LINE_AMOUNT_ORIG(RACTRX.CUSTOMER_TRX_ID
, RACTRL.CUSTOMER_TRX_LINE_ID) AMOUNT_DUE_ORIGINAL
, APS.DUE_DATE DUE_DATE
, SM.ID STREAM_TYPE_ID
, TXD.LATE_CHARGE_ASS_YN LATE_CHARGE_ASS_YN
, TXD.LATE_CHARGE_ASSESS_DATE LATE_CHARGE_ASSESS_DATE
, TXD.LATE_INT_ASS_YN LATE_INT_ASS_YN
, TXD.LATE_INT_ASSESS_DATE LATE_INT_ASSESS_DATE
, TXD.SEL_ID SEL_ID
, TXD.ID ID
, RACTRX.TRX_NUMBER TRX_NUMBER
, TXD.TIL_ID_DETAILS TIL_ID_DETAILS
, (RACTRL.QUANTITY_INVOICED * RACTRL.UNIT_SELLING_PRICE) AMOUNT
, RACTRL.INTERFACE_LINE_CONTEXT INTERFACE_LINE_CONTEXT
, TXD.STY_ID STY_ID
, APS.CLASS CLASS
, RACTRL.LINE_NUMBER LINE_NUMBER
, RACTRX.INVOICE_CURRENCY_CODE CURRENCY_CODE
, RACTRL.CUSTOMER_TRX_LINE_ID RECEIVABLES_INVOICE_LINE_ID
, RACTRX.BILL_TO_CUSTOMER_ID IXX_ID
, (SELECT SUM(EXTENDED_AMOUNT)
FROM RA_CUSTOMER_TRX_LINES_ALL TRXL
WHERE TRXL.LINK_TO_CUST_TRX_LINE_ID = RACTRL.CUSTOMER_TRX_LINE_ID
AND TRXL.LINE_TYPE = 'TAX') TAX_AMOUNT
, /* RACTRL.AMOUNT_DUE_REMAINING AMOUNT_LINE_ITEMS_REMAINING
, */ OKL_BILLING_UTIL_PVT.INVOICE_LINE_AMOUNT_REMAINING(RACTRX.CUSTOMER_TRX_ID
, RACTRL.CUSTOMER_TRX_LINE_ID) AMOUNT_LINE_ITEMS_REMAINING
, RACTRL.INTERFACE_LINE_ATTRIBUTE8 LINE_TYPE
, RACTRL.LINE_TYPE TXN_LINE_TYPE
, RACTRX.ORG_ID ORG_ID
FROM RA_CUSTOMER_TRX_LINES_ALL RACTRL
, OKL_TXD_AR_LN_DTLS_B TXD
, RA_CUSTOMER_TRX_ALL RACTRX
, OKL_STRM_TYPE_B SM
, OKL_TXL_AR_INV_LNS_B TIL
, AR_PAYMENT_SCHEDULES_ALL APS
WHERE TXD.ID = RACTRL.INTERFACE_LINE_ATTRIBUTE14 /*-- ASSUME TXD ID MAP*/
AND RACTRL.CUSTOMER_TRX_ID = RACTRX.CUSTOMER_TRX_ID
AND SM.ID = TXD.STY_ID
AND TXD.TIL_ID_DETAILS = TIL.ID
AND RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID

Columns