DBA Data[Home] [Help]

APPS.OKL_CS_TRANSACTIONS_PVT dependencies on OKL_BILLING_UTIL_PVT

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

249: SELECT DISTINCT STYT.NAME
250: ,RACTRX.TRX_NUMBER CONSOLIDATED_INVOICE_NUMBER
251: ,APS.TRX_DATE
252: ,RACTRL.AMOUNT_DUE_ORIGINAL
253: ,OKL_BILLING_UTIL_PVT.INVOICE_LINE_AMOUNT_APPLIED(RACTRX.customer_trx_id, RACTRL.customer_trx_line_id) AMOUNT_APPLIED
254: ,RACTRL.AMOUNT_DUE_REMAINING
255: ,TIL.Amount
256: from OKL_TRX_AR_INVOICES_B TAI
257: ,OKL_TXL_AR_INV_LNS_B TIL