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 444: ap_invoices_all aia

440: aida.price_var_code_combination_id inv_dist_ccid
441: FROM po_distributions_all pda,
442: ap_invoice_distributions_all aida,
443: ap_invoice_lines_all aila,
444: ap_invoices_all aia
445: WHERE EXISTS (
446: SELECT '1' FROM csi_transactions ct
447: WHERE ct.transaction_type_id = 105
448: AND ct.transaction_status_code = 'COMPLETE'

Line 498: ap_invoices_all aia

494: aida.accounting_date,
495: aida.dist_code_combination_id inv_dist_ccid
496: FROM ap_invoice_distributions_all aida,
497: ap_invoice_distributions_all aida1,
498: ap_invoices_all aia
499: WHERE aida.invoice_id = p_invoice_id
500: AND aida.project_id = p_project_id
501: AND aida.task_id = p_task_id
502: AND aida.line_type_lookup_code IN ('FREIGHT', 'REC_TAX',

Line 659: FROM ap_invoices_all

655: debug(' task_number : '||l_ap_pa_tbl(1).task_num);
656:
657: SELECT vendor_id
658: INTO l_ap_pa_tbl(1).vendor_id
659: FROM ap_invoices_all
660: WHERE invoice_id = ap_inv_rec.invoice_id;
661:
662: debug(' vendor_id : '||l_ap_pa_tbl(1).vendor_id);
663: