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_TRX_AR_INVOICES_V

Line 152: ,okl_trx_ar_invoices_v tai

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
156: and tai.id = til.tai_id

Line 168: ,okl_trx_ar_invoices_v tai

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
172: and tai.id = til.tai_id

Line 521: ,okl_trx_ar_invoices_v tai1 where

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
525: xls1.lsm_id =ocas.id

Line 543: ,okl_trx_ar_invoices_v tai1 where

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
547: tai1.cpy_id IS NOT NULL and

Line 651: ,okl_trx_ar_invoices_v tai1 where

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
655: xls1.lsm_id =ocas.id

Line 672: ,okl_trx_ar_invoices_v tai1 where

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
676: tld.id =ocas.tld_id

Line 1164: ,okl_trx_ar_invoices_v tai1 where

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
1168: xls1.lsm_id =ocas.id);*/

Line 1187: ,okl_trx_ar_invoices_v tai1 where

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
1191: tai1.cpy_id IS NOT NULL and

Line 1317: ,okl_trx_ar_invoices_v tai

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
1321: and stream.id =xls.lsm_id

Line 1335: ,okl_trx_ar_invoices_v tai

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
1339: --and stream.id =xls.lsm_id