eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CS_TRANSACTIONS_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 200: ,OKL_TXL_AR_INV_LNS_B TIL

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
204: ,OKL_XTL_SELL_INVS_V XLS

Line 228: ,OKL_TXL_AR_INV_LNS_B TIL2

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
232: ,OKC_K_HEADERS_V CHR

Line 229: ,OKL_TXL_AR_INV_LNS_B TIL

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
232: ,OKC_K_HEADERS_V CHR
233: ,OKL_CNSLD_AR_STRMS_B LSM

Line 257: ,OKL_TXL_AR_INV_LNS_B TIL

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
261: ,OKC_K_HEADERS_V CHR

Line 283: ,OKL_TXL_AR_INV_LNS_B TIL

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
287: ,OKC_K_HEADERS_V CHR

Line 323: ,OKL_TXL_AR_INV_LNS_B TIL

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
327: ,OKC_K_HEADERS_V CHR

Line 963: l_dist_info_rec.SOURCE_TABLE := 'OKL_TXL_AR_INV_LNS_B';

959: l_tmpl_identify_rec.MEMO_YN := 'N';
960: l_tmpl_identify_rec.PRIOR_YEAR_YN := 'N';
961:
962: l_dist_info_rec.SOURCE_ID := r_tilv_rec.id;
963: l_dist_info_rec.SOURCE_TABLE := 'OKL_TXL_AR_INV_LNS_B';
964: l_dist_info_rec.ACCOUNTING_DATE := l_sysdate;
965: l_dist_info_rec.GL_REVERSAL_FLAG := 'N';
966: l_dist_info_rec.POST_TO_GL := 'N';
967: l_dist_info_rec.AMOUNT := l_svf_amount;

Line 1005: l_bpd_acc_rec.source_table := 'OKL_TXL_AR_INV_LNS_B';

1001: ------------------------------------------------------
1002: -- Create distributions using Accounting Engine
1003: ------------------------------------------------------
1004: l_bpd_acc_rec.id := r_tilv_rec.id;
1005: l_bpd_acc_rec.source_table := 'OKL_TXL_AR_INV_LNS_B';
1006: ----------------------------------------------------
1007: -- Create Accounting Distributions
1008: ----------------------------------------------------
1009: Okl_Acc_Call_Pub.CREATE_ACC_TRANS(