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_TXL_AR_INV_LNS_V

Line 408: ,okl_txl_ar_inv_lns_v til1

404: AND NVL(aps.amount_due_remaining, 0) = 0
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

Line 431: ,okl_txl_ar_inv_lns_v til1

427: --(select xls1.lsm_id from
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

Line 577: ,okl_txl_ar_inv_lns_v til

573: select count( ps.payment_schedule_id)
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

Line 595: ,okl_txl_ar_inv_lns_v til

591: from ar_payment_schedules_all ps
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

Line 635: ,okl_txl_ar_inv_lns_v til1

631: AND ocas.khr_id=chr.id
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

Line 659: ,okl_txl_ar_inv_lns_v til1

655: --( select xls1.lsm_id from
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