DBA Data[Home] [Help]

APPS.OKL_CS_TRANSACTIONS_PVT dependencies on OKL_BILLING_UTIL_PVT

Line 263: ,OKL_BILLING_UTIL_PVT.INVOICE_LINE_AMOUNT_APPLIED(RACTRX.customer_trx_id, RACTRL.customer_trx_line_id) AMOUNT_APPLIED

259: SELECT DISTINCT STYT.NAME
260: ,RACTRX.TRX_NUMBER CONSOLIDATED_INVOICE_NUMBER
261: ,APS.TRX_DATE
262: ,RACTRL.AMOUNT_DUE_ORIGINAL
263: ,OKL_BILLING_UTIL_PVT.INVOICE_LINE_AMOUNT_APPLIED(RACTRX.customer_trx_id, RACTRL.customer_trx_line_id) AMOUNT_APPLIED
264: ,RACTRL.AMOUNT_DUE_REMAINING
265: ,TIL.Amount
266: from OKL_TRX_AR_INVOICES_B TAI
267: ,OKL_TXL_AR_INV_LNS_B TIL