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.CSE_AP_PA_PKG dependencies on AP_INVOICES_ALL

Line 431: ap_invoices_all aia

427: aida.price_var_code_combination_id inv_dist_ccid
428: FROM po_distributions_all pda,
429: ap_invoice_distributions_all aida,
430: ap_invoice_lines_all aila,
431: ap_invoices_all aia
432: WHERE EXISTS (
433: SELECT '1' FROM csi_transactions ct
434: WHERE ct.transaction_type_id = 105
435: AND ct.transaction_status_code = 'COMPLETE'

Line 483: ap_invoices_all aia

479: nvl(aida.amount,0) base_amount,
480: aida.accounting_date,
481: aida.dist_code_combination_id inv_dist_ccid
482: FROM ap_invoice_distributions_all aida,
483: ap_invoices_all aia
484: WHERE aida.invoice_id = p_invoice_id
485: AND aida.project_id = p_project_id
486: AND aida.task_id = p_task_id
487: AND aida.line_type_lookup_code IN ('FREIGHT', 'TAX', 'NONREC_TAX')

Line 634: FROM ap_invoices_all

630: debug(' task_number : '||l_ap_pa_tbl(1).task_num);
631:
632: SELECT vendor_id
633: INTO l_ap_pa_tbl(1).vendor_id
634: FROM ap_invoices_all
635: WHERE invoice_id = ap_inv_rec.invoice_id;
636:
637: debug(' vendor_id : '||l_ap_pa_tbl(1).vendor_id);
638: