APPS.OKL_CS_TRANSACTIONS_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 209: from OKL_TRX_AR_INVOICES_B TAI

205: select STYT.NAME,CNR.CONSOLIDATED_INVOICE_NUMBER
206: ,APS.TRX_DATE,APS.AMOUNT_DUE_ORIGINAL,
207: APS.AMOUNT_APPLIED,APS.AMOUNT_DUE_REMAINING
208: ,TIL.Amount
209: from OKL_TRX_AR_INVOICES_B TAI
210: ,OKL_TXL_AR_INV_LNS_B TIL
211: ,OKL_TXD_AR_LN_DTLS_B TLD2
212: ,OKL_TXD_AR_LN_DTLS_B TLD
213: ,OKL_STRM_TYPE_TL STYT

Line 237: from OKL_TRX_AR_INVOICES_B TAI

233: select STYT.NAME,CNR.CONSOLIDATED_INVOICE_NUMBER
234: ,APS.TRX_DATE,APS.AMOUNT_DUE_ORIGINAL,
235: APS.AMOUNT_APPLIED,APS.AMOUNT_DUE_REMAINING
236: ,TIL.Amount
237: from OKL_TRX_AR_INVOICES_B TAI
238: ,OKL_TXL_AR_INV_LNS_B TIL2
239: ,OKL_TXL_AR_INV_LNS_B TIL
240: ,OKL_STRM_TYPE_TL STYT
241: ,OKL_XTL_SELL_INVS_V XLS

Line 266: from OKL_TRX_AR_INVOICES_B TAI

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
268: ,OKL_TXD_AR_LN_DTLS_B TLD2
269: ,OKL_TXD_AR_LN_DTLS_B TLD
270: ,OKL_STRM_TYPE_TL STYT

Line 292: from OKL_TRX_AR_INVOICES_B TAI

288: /*select STYT.NAME,CNR.CONSOLIDATED_INVOICE_NUMBER
289: ,APS.TRX_DATE,APS.AMOUNT_DUE_ORIGINAL,
290: APS.AMOUNT_APPLIED,APS.AMOUNT_DUE_REMAINING
291: ,TIL.Amount
292: from OKL_TRX_AR_INVOICES_B TAI
293: ,OKL_TXL_AR_INV_LNS_B TIL
294: ,OKL_TXD_AR_LN_DTLS_B TLD
295: ,OKL_STRM_TYPE_TL STYT
296: ,OKL_XTL_SELL_INVS_V XLS

Line 332: from OKL_TRX_AR_INVOICES_B TAI

328: select STYT.NAME,CNR.CONSOLIDATED_INVOICE_NUMBER
329: ,APS.TRX_DATE,APS.AMOUNT_DUE_ORIGINAL,
330: APS.AMOUNT_APPLIED,APS.AMOUNT_DUE_REMAINING
331: ,TIL.Amount
332: from OKL_TRX_AR_INVOICES_B TAI
333: ,OKL_TXL_AR_INV_LNS_B TIL
334: ,OKL_TXD_AR_LN_DTLS_B TLD
335: ,OKL_STRM_TYPE_TL STYT
336: ,OKL_XTL_SELL_INVS_V XLS