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_PO_EMISSIONS_PKG dependencies on GHG_TRANSACTIONS_V

Line 56: FROM GHG_TRANSACTIONS_V

52: v_invoice_msg VARCHAR2(4000);
53:
54: CURSOR get_emissions (i_invoice_id NUMBER) IS
55: SELECT transaction_id
56: FROM GHG_TRANSACTIONS_V
57: WHERE invoice_id = i_invoice_id;
58:
59: CURSOR get_invoice_distributions (i_invoice_id NUMBER) IS
60: SELECT ai.invoice_date,

Line 159: FROM GHG_TRANSACTIONS_V

155: -- Determine the last emission line number for the current invoice.
156: SELECT NVL((MAX(transaction_line_number)), 0)
157: INTO v_highest_emission_number
158: FROM (SELECT MAX(transaction_line_number) transaction_line_number
159: FROM GHG_TRANSACTIONS_V
160: WHERE invoice_id = x_invoice_id
161: UNION
162: SELECT MAX(transaction_line_number) transaction_line_number
163: FROM GHG_TRANSACTIONS_HISTORY_V