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_VENDOR_REFUND_PVT dependencies on OKL_TRX_AR_INVOICES_V

Line 409: ,okl_trx_ar_invoices_v tai1 where

405: AND not exists
406: (select xls1.lsm_id from
407: okl_xtl_sell_invs_v xls1
408: ,okl_txl_ar_inv_lns_v til1
409: ,okl_trx_ar_invoices_v tai1 where
410: tai1.id = til1.tai_id and
411: til1.id = xls1.til_id and
412: tai1.cpy_id IS NOT NULL and
413: xls1.lsm_id =ocas.id);*/

Line 432: ,okl_trx_ar_invoices_v tai1

428: (SELECT tld.id
429: FROM --okl_xtl_sell_invs_v xls1
430: okl_txd_ar_ln_dtls_b tld
431: ,okl_txl_ar_inv_lns_v til1
432: ,okl_trx_ar_invoices_v tai1
433: WHERE tai1.id = til1.tai_id
434: AND
435: --til1.id = xls1.til_id and
436: til1.id = tld.til_id_details

Line 578: ,okl_trx_ar_invoices_v tai

574: from ar_payment_schedules_all ps
575: ,okl_cnsld_ar_strms_b stream
576: ,okl_xtl_sell_invs_v xls
577: ,okl_txl_ar_inv_lns_v til
578: ,okl_trx_ar_invoices_v tai
579: where ps.class ='INV'
580: and ps.amount_due_remaining = 0
581: and stream.receivables_invoice_id = ps.customer_trx_id
582: and stream.id = xls.lsm_id

Line 596: ,okl_trx_ar_invoices_v tai

592: ,okl_bpd_tld_ar_lines_v stream
593: --,okl_xtl_sell_invs_v xls
594: ,okl_txd_ar_ln_dtls_b tld
595: ,okl_txl_ar_inv_lns_v til
596: ,okl_trx_ar_invoices_v tai
597: where ps.class ='INV'
598: and ps.amount_due_remaining = 0
599: and stream.customer_trx_id = ps.customer_trx_id
600: --and stream.id = xls.lsm_id

Line 636: ,okl_trx_ar_invoices_v tai1 where

632: AND not exists
633: ( select xls1.lsm_id from
634: okl_xtl_sell_invs_v xls1
635: ,okl_txl_ar_inv_lns_v til1
636: ,okl_trx_ar_invoices_v tai1 where
637: tai1.id = til1.tai_id
638: and til1.id = xls1.til_id and
639: tai1.cpy_id IS NOT NULL and
640: xls1.lsm_id =ocas.id);*/

Line 660: ,okl_trx_ar_invoices_v tai1 where

656: ( select tld.id from
657: --okl_xtl_sell_invs_v xls1
658: okl_txd_ar_ln_dtls_b tld
659: ,okl_txl_ar_inv_lns_v til1
660: ,okl_trx_ar_invoices_v tai1 where
661: tai1.id = til1.tai_id
662: --and til1.id = xls1.til_id and
663: and til1.id = tld.til_id_details and
664: tai1.cpy_id IS NOT NULL and