eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_BPD_AR_INV_LINES_V

Source

View Text - Preformatted


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, OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_WOTAX (RACTRX.CUSTOMER_TRX_ID, RACTRL.CUSTOMER_TRX_LINE_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 TO_CHAR(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

View Text - HTML Formatted

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
, OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_WOTAX (RACTRX.CUSTOMER_TRX_ID
, RACTRL.CUSTOMER_TRX_LINE_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 TO_CHAR(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