View: OKL_IN_RAMOUNT_BC_V

Product:	OKL - Lease and Finance Management
Description:	View for amount received for the invoice line.
Implementation/DBA Data:	APPS.OKL_IN_RAMOUNT_BC_V

View Text

SELECT SUM(RACTRL.AMOUNT_DUE_ORIGINAL - RACTRL.AMOUNT_DUE_REMAINING) AMOUNT_RECEIVED
, TIL.KLE_ID KLE_ID
FROM RA_CUSTOMER_TRX_LINES_ALL RACTRL
, OKL_TXL_AR_INV_LNS_B TIL
, OKL_TXD_AR_LN_DTLS_B TLD
WHERE TLD.ID = RACTRL.INTERFACE_LINE_ATTRIBUTE14 /*-- ASSUME 14 HAS TLD ID*/
AND TLD.TIL_ID_DETAILS = TIL.ID GROUP BY TIL.KLE_ID

Columns