View: OKL_BPD_AR_LINES_V

Product:	OKL - Lease and Finance Management
Description:	View for Operations, Transactions Details page for contract.
Implementation/DBA Data:	APPS.OKL_BPD_AR_LINES_V

View Text

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*/

Columns