VIEW: APPS.OKL_IN_RAMOUNT_UV

Source

View Text - Preformatted

SELECT SUM(AR.AMOUNT_DUE_ORIGINAL-AR.AMOUNT_DUE_REMAINING) AMOUNT_RECEIVED, TIL.KLE_ID KLE_ID FROM FND_LOOKUPS FLT,AR_PAYMENT_SCHEDULES_ALL AR,OKL_EXT_SELL_INVS_B XSI,OKL_XTL_SELL_INVS_B XLS,OKL_TXD_AR_LN_DTLS_B TLD,OKL_TXL_AR_INV_LNS_B TIL,OKL_TRX_AR_INVOICES_B TAI WHERE XSI.RECEIVABLES_INVOICE_ID = AR.PAYMENT_SCHEDULE_ID AND XSI.ID = XLS.XSI_ID_DETAILS AND XSI.trx_status_code = flt.lookup_code AND flt.lookup_type = 'OKL_TRANSACTION_STATUS' AND XLS.TLD_ID = TLD.ID AND TLD.TIL_ID_DETAILS = TIL.ID AND TIL.TAI_ID = TAI.ID GROUP BY TIL.KLE_ID

View Text - HTML Formatted

SELECT SUM(AR.AMOUNT_DUE_ORIGINAL-AR.AMOUNT_DUE_REMAINING) AMOUNT_RECEIVED
, TIL.KLE_ID KLE_ID
FROM FND_LOOKUPS FLT
, AR_PAYMENT_SCHEDULES_ALL AR
, OKL_EXT_SELL_INVS_B XSI
, OKL_XTL_SELL_INVS_B XLS
, OKL_TXD_AR_LN_DTLS_B TLD
, OKL_TXL_AR_INV_LNS_B TIL
, OKL_TRX_AR_INVOICES_B TAI
WHERE XSI.RECEIVABLES_INVOICE_ID = AR.PAYMENT_SCHEDULE_ID
AND XSI.ID = XLS.XSI_ID_DETAILS
AND XSI.TRX_STATUS_CODE = FLT.LOOKUP_CODE
AND FLT.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS'
AND XLS.TLD_ID = TLD.ID
AND TLD.TIL_ID_DETAILS = TIL.ID
AND TIL.TAI_ID = TAI.ID GROUP BY TIL.KLE_ID