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.GHG_TRANSACTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_V

Line 648: ap_invoice_distributions_v aid,

644: aid.dist_code_combination_id code_combination_id,
645: aid.project,
646: aid.task
647: FROM ap_invoices_all ai,
648: ap_invoice_distributions_v aid,
649: fnd_lookup_values xnlv
650: WHERE ai.invoice_id = p_invoice_id
651: AND aid.invoice_id = ai.invoice_id
652: AND xnlv.lookup_code = aid.line_type_lookup_code

Line 678: ap_invoice_distributions_v aid,

674: -- Get Invoice Item Total
675: SELECT sum(aid.amount)
676: INTO v_invoice_item_total
677: FROM ap_invoices_all ai,
678: ap_invoice_distributions_v aid,
679: fnd_lookup_values xnlv
680: WHERE ai.invoice_id = p_invoice_id
681: AND aid.invoice_id = ai.invoice_id
682: AND xnlv.lookup_code = aid.line_type_lookup_code