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_LINES_V

Source

View Text - Preformatted


SELECT RACTRL.CUSTOMER_TRX_LINE_ID ID, RACTRL.CUSTOMER_TRX_ID CUSTOMER_TRX_ID, RACTRL.INTERFACE_LINE_ATTRIBUTE6 CONTRACT_NUMBER, RACTRL.LINE_NUMBER LINE_NUMBER, RACTRL.DESCRIPTION DESCRIPTION, RACTRL.INTERFACE_LINE_ATTRIBUTE9 STREAM_TYPE, STRM.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE, /* (RACTRL.QUANTITY_INVOICED * RACTRL.UNIT_SELLING_PRICE) LINE_AMOUNT, */ OKL_BILLING_UTIL_PVT.INVOICE_LINE_AMOUNT_ORIG(RACTRL.CUSTOMER_TRX_ID, RACTRL.CUSTOMER_TRX_LINE_ID) LINE_AMOUNT, TLD.KHR_ID KHR_ID FROM RA_CUSTOMER_TRX_LINES_ALL RACTRL,OKL_STRM_TYPE_B STRM,OKL_TXD_AR_LN_DTLS_B TLD WHERE TLD.STY_ID = STRM.ID AND TLD.ID = RACTRL.INTERFACE_LINE_ATTRIBUTE14 /*-- Assume TLD ID on 14*/

View Text - HTML Formatted

SELECT RACTRL.CUSTOMER_TRX_LINE_ID ID
, RACTRL.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, RACTRL.INTERFACE_LINE_ATTRIBUTE6 CONTRACT_NUMBER
, RACTRL.LINE_NUMBER LINE_NUMBER
, RACTRL.DESCRIPTION DESCRIPTION
, RACTRL.INTERFACE_LINE_ATTRIBUTE9 STREAM_TYPE
, STRM.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE
, /* (RACTRL.QUANTITY_INVOICED * RACTRL.UNIT_SELLING_PRICE) LINE_AMOUNT
, */ OKL_BILLING_UTIL_PVT.INVOICE_LINE_AMOUNT_ORIG(RACTRL.CUSTOMER_TRX_ID
, RACTRL.CUSTOMER_TRX_LINE_ID) LINE_AMOUNT
, TLD.KHR_ID KHR_ID
FROM RA_CUSTOMER_TRX_LINES_ALL RACTRL
, OKL_STRM_TYPE_B STRM
, OKL_TXD_AR_LN_DTLS_B TLD
WHERE TLD.STY_ID = STRM.ID
AND TLD.ID = RACTRL.INTERFACE_LINE_ATTRIBUTE14 /*-- ASSUME TLD ID ON 14*/