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_CURE_CALC_PVT dependencies on OKL_TXL_AR_INV_LNS_V

Line 151: ,okl_txl_ar_inv_lns_v til

147: from ar_payment_schedules ps1,
148: okl_cnsld_ar_strms_b st1
149: ,ar_receivable_applications ara
150: ,okl_xtl_sell_invs_v xls
151: ,okl_txl_ar_inv_lns_v til
152: ,okl_trx_ar_invoices_v tai
153: where st1.receivables_invoice_id = ps1.customer_trx_id
154: and ara.applied_payment_schedule_id = ps1.payment_schedule_id
155: and st1.id =xls.lsm_id

Line 167: ,okl_txl_ar_inv_lns_v til

163: from ar_payment_schedules ps1,
164: okl_bpd_tld_ar_lines_v st1
165: ,ar_receivable_applications ara
166: --,okl_xtl_sell_invs_v xls
167: ,okl_txl_ar_inv_lns_v til
168: ,okl_trx_ar_invoices_v tai
169: where st1.customer_trx_id = ps1.customer_trx_id
170: and ara.applied_payment_schedule_id = ps1.payment_schedule_id
171: --and st1.id =xls.lsm_id

Line 520: ,okl_txl_ar_inv_lns_v til1

516: AND NVL(aps.amount_due_remaining, 0) > 0
517: and not exists
518: (select xls1.lsm_id from
519: okl_xtl_sell_invs_v xls1
520: ,okl_txl_ar_inv_lns_v til1
521: ,okl_trx_ar_invoices_v tai1 where
522: tai1.id = til1.tai_id and
523: til1.id = xls1.til_id and
524: tai1.cpy_id IS NOT NULL and

Line 542: ,okl_txl_ar_inv_lns_v til1

538: and not exists
539: (select tld.id from
540: --okl_xtl_sell_invs_v xls1
541: okl_txd_ar_ln_dtls_b tld
542: ,okl_txl_ar_inv_lns_v til1
543: ,okl_trx_ar_invoices_v tai1 where
544: tai1.id = til1.tai_id and
545: --til1.id = xls1.til_id and
546: til1.id = tld.til_id_details and

Line 650: ,okl_txl_ar_inv_lns_v til1

646: AND NVL(aps.amount_due_remaining, 0) > 0
647: and not exists
648: (select xls1.lsm_id from
649: okl_xtl_sell_invs_v xls1
650: ,okl_txl_ar_inv_lns_v til1
651: ,okl_trx_ar_invoices_v tai1 where
652: tai1.id = til1.tai_id and
653: til1.id = xls1.til_id and
654: tai1.cpy_id IS NOT NULL and

Line 671: ,okl_txl_ar_inv_lns_v til1

667: AND NVL(aps.amount_due_remaining, 0) > 0
668: and not exists
669: (select tld.id from
670: okl_txd_ar_ln_dtls_b tld
671: ,okl_txl_ar_inv_lns_v til1
672: ,okl_trx_ar_invoices_v tai1 where
673: tai1.id = til1.tai_id and
674: til1.id = tld.til_id_details and
675: tai1.cpy_id IS NOT NULL and

Line 1163: ,okl_txl_ar_inv_lns_v til1

1159: AND NVL(aps.amount_due_remaining, 0) > 0
1160: AND not exists
1161: (select xls1.lsm_id from
1162: okl_xtl_sell_invs_v xls1
1163: ,okl_txl_ar_inv_lns_v til1
1164: ,okl_trx_ar_invoices_v tai1 where
1165: tai1.id = til1.tai_id and
1166: til1.id = xls1.til_id and
1167: tai1.cpy_id IS NOT NULL and

Line 1186: ,okl_txl_ar_inv_lns_v til1

1182: --(select xls1.lsm_id from
1183: (select tld.id from
1184: --okl_xtl_sell_invs_v xls1
1185: okl_txd_ar_ln_dtls_b tld
1186: ,okl_txl_ar_inv_lns_v til1
1187: ,okl_trx_ar_invoices_v tai1 where
1188: tai1.id = til1.tai_id and
1189: --til1.id = xls1.til_id and
1190: til1.id = tld.til_id_details and

Line 1316: ,okl_txl_ar_inv_lns_v til

1312: select count( ps.payment_schedule_id)
1313: from ar_payment_schedules ps
1314: ,okl_cnsld_ar_strms_b stream
1315: ,okl_xtl_sell_invs_v xls
1316: ,okl_txl_ar_inv_lns_v til
1317: ,okl_trx_ar_invoices_v tai
1318: where ps.class ='INV'
1319: and ps.amount_due_remaining = 0
1320: and stream.receivables_invoice_id = ps.customer_trx_id

Line 1334: ,okl_txl_ar_inv_lns_v til

1330: from ar_payment_schedules ps
1331: ,okl_bpd_tld_ar_lines_v stream
1332: --,okl_xtl_sell_invs_v xls
1333: ,okl_txd_ar_ln_dtls_b tld
1334: ,okl_txl_ar_inv_lns_v til
1335: ,okl_trx_ar_invoices_v tai
1336: where ps.class ='INV'
1337: and ps.amount_due_remaining = 0
1338: and stream.customer_trx_id = ps.customer_trx_id