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_UTILITIES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_V

Line 250: ap_invoice_distributions_v aid,

246: aid.project,
247: aid.task,
248: aid.po_number
249: FROM ap_invoices_all ai,
250: ap_invoice_distributions_v aid,
251: fnd_lookup_values_vl xnlv
252: WHERE ai.invoice_id = p_invoice_id
253: AND aid.invoice_id = ai.invoice_id
254: AND xnlv.lookup_code = aid.line_type_lookup_code

Line 432: from ap_invoice_distributions_v v

428: vl_inv_perc NUMBER;
429: BEGIN
430: select sum(amount)
431: into vl_invoice_total
432: from ap_invoice_distributions_v v
433: where invoice_id = x_invoice_id
434: and nvl(reversal_flag,'N') <> 'Y'
435: and line_type_lookup_code in
436: (SELECT LOOKUP_CODE

Line 445: from ap_invoice_distributions_v

441: );
442:
443: select amount/vl_invoice_total
444: into vl_inv_perc
445: from ap_invoice_distributions_v
446: where invoice_id = x_invoice_id
447: and distribution_line_number = x_dist_line_num
448: and invoice_line_number = x_inv_line_num;
449: