APPS.OKL_CS_TRANSACTIONS_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 199: from OKL_TRX_AR_INVOICES_B TAI

195: select STYT.NAME,CNR.CONSOLIDATED_INVOICE_NUMBER
196: ,APS.TRX_DATE,APS.AMOUNT_DUE_ORIGINAL,
197: APS.AMOUNT_APPLIED,APS.AMOUNT_DUE_REMAINING
198: ,TIL.Amount
199: from OKL_TRX_AR_INVOICES_B TAI
200: ,OKL_TXL_AR_INV_LNS_B TIL
201: ,OKL_TXD_AR_LN_DTLS_B TLD2
202: ,OKL_TXD_AR_LN_DTLS_B TLD
203: ,OKL_STRM_TYPE_TL STYT

Line 227: from OKL_TRX_AR_INVOICES_B TAI

223: select STYT.NAME,CNR.CONSOLIDATED_INVOICE_NUMBER
224: ,APS.TRX_DATE,APS.AMOUNT_DUE_ORIGINAL,
225: APS.AMOUNT_APPLIED,APS.AMOUNT_DUE_REMAINING
226: ,TIL.Amount
227: from OKL_TRX_AR_INVOICES_B TAI
228: ,OKL_TXL_AR_INV_LNS_B TIL2
229: ,OKL_TXL_AR_INV_LNS_B TIL
230: ,OKL_STRM_TYPE_TL STYT
231: ,OKL_XTL_SELL_INVS_V XLS

Line 256: from OKL_TRX_AR_INVOICES_B TAI

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
258: ,OKL_TXD_AR_LN_DTLS_B TLD2
259: ,OKL_TXD_AR_LN_DTLS_B TLD
260: ,OKL_STRM_TYPE_TL STYT

Line 282: from OKL_TRX_AR_INVOICES_B TAI

278: /*select STYT.NAME,CNR.CONSOLIDATED_INVOICE_NUMBER
279: ,APS.TRX_DATE,APS.AMOUNT_DUE_ORIGINAL,
280: APS.AMOUNT_APPLIED,APS.AMOUNT_DUE_REMAINING
281: ,TIL.Amount
282: from OKL_TRX_AR_INVOICES_B TAI
283: ,OKL_TXL_AR_INV_LNS_B TIL
284: ,OKL_TXD_AR_LN_DTLS_B TLD
285: ,OKL_STRM_TYPE_TL STYT
286: ,OKL_XTL_SELL_INVS_V XLS

Line 322: from OKL_TRX_AR_INVOICES_B TAI

318: select STYT.NAME,CNR.CONSOLIDATED_INVOICE_NUMBER
319: ,APS.TRX_DATE,APS.AMOUNT_DUE_ORIGINAL,
320: APS.AMOUNT_APPLIED,APS.AMOUNT_DUE_REMAINING
321: ,TIL.Amount
322: from OKL_TRX_AR_INVOICES_B TAI
323: ,OKL_TXL_AR_INV_LNS_B TIL
324: ,OKL_TXD_AR_LN_DTLS_B TLD
325: ,OKL_STRM_TYPE_TL STYT
326: ,OKL_XTL_SELL_INVS_V XLS