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_IPV_FA_PKG dependencies on AP_INVOICES_ALL

Line 65: from ap_invoices_all aia,

61: aida.distribution_line_number distribution_line_number,
62: aida.quantity_invoiced quantity_invoiced,
63: aida.base_invoice_price_variance base_invoice_price_variance,
64: cte.error_text error_text
65: from ap_invoices_all aia,
66: ap_invoice_distributions_all aida,
67: csi_txn_errors cte
68: where aida.invoice_id = aia.invoice_id
69: and cte.source_id = aida.invoice_distribution_id

Line 533: ap_invoices_all aia

529: aila.inventory_item_id,
530: aila.org_id
531: FROM ap_invoice_distributions_all aida,
532: ap_invoice_lines_all aila,
533: ap_invoices_all aia
534: WHERE aida.line_type_lookup_code = 'IPV'
535: AND aida.posted_flag = 'Y'
536: AND aida.assets_addition_flag IN ('U','I','N')
537: --AND NVL(aida.assets_tracking_flag,'x') = 'Y'

Line 578: ap_invoices_all aia

574: nvl(aida.amount,0) base_amount,
575: aida.accounting_date,
576: aida.dist_code_combination_id inv_dist_ccid
577: FROM ap_invoice_distributions_all aida,
578: ap_invoices_all aia
579: WHERE aida.invoice_id = p_invoice_id
580: AND aida.project_id = p_project_id
581: AND aida.task_id = p_task_id
582: AND aida.line_type_lookup_code IN ('FREIGHT', 'TAX', 'NONREC_TAX')