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 210: ,OKL_TXL_AR_INV_LNS_B TIL

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

Line 238: ,OKL_TXL_AR_INV_LNS_B TIL2

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

Line 239: ,OKL_TXL_AR_INV_LNS_B TIL

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
242: ,OKC_K_HEADERS_V CHR
243: ,OKL_CNSLD_AR_STRMS_B LSM

Line 267: ,OKL_TXL_AR_INV_LNS_B TIL

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

Line 293: ,OKL_TXL_AR_INV_LNS_B TIL

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

Line 333: ,OKL_TXL_AR_INV_LNS_B TIL

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

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

969: l_tmpl_identify_rec.MEMO_YN := 'N';
970: l_tmpl_identify_rec.PRIOR_YEAR_YN := 'N';
971:
972: l_dist_info_rec.SOURCE_ID := r_tilv_rec.id;
973: l_dist_info_rec.SOURCE_TABLE := 'OKL_TXL_AR_INV_LNS_B';
974: l_dist_info_rec.ACCOUNTING_DATE := l_sysdate;
975: l_dist_info_rec.GL_REVERSAL_FLAG := 'N';
976: l_dist_info_rec.POST_TO_GL := 'N';
977: l_dist_info_rec.AMOUNT := l_svf_amount;

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

1011: ------------------------------------------------------
1012: -- Create distributions using Accounting Engine
1013: ------------------------------------------------------
1014: l_bpd_acc_rec.id := r_tilv_rec.id;
1015: l_bpd_acc_rec.source_table := 'OKL_TXL_AR_INV_LNS_B';
1016: ----------------------------------------------------
1017: -- Create Accounting Distributions
1018: ----------------------------------------------------
1019: Okl_Acc_Call_Pub.CREATE_ACC_TRANS(