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.GMS_AP_API2 dependencies on GMS_PROJECT_TYPES

Line 159: gms_project_types gpt,

155: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
156: inv.invoice_num invoice_num
157: from ap_invoice_distributions_all A,
158: pa_projects_all p,
159: gms_project_types gpt,
160: ap_invoices_all inv
161: where a.invoice_id = p_invoice_id
162: and a.project_id = p.project_id
163: and p.project_type = gpt.project_type

Line 176: gms_project_types gpt

172: cursor c2 is
173: SELECT 1
174: from ap_invoice_distributions_all A,
175: pa_projects_all p,
176: gms_project_types gpt
177: where a.invoice_id = p_invoice_id
178: and a.project_id = p.project_id
179: and p.project_type = gpt.project_type
180: and gpt.sponsored_flag = 'Y'

Line 346: gms_project_types gpt

342: select a.invoice_distribution_id
343: bulk collect into l_dummy_tab
344: from ap_invoice_distributions_all A,
345: pa_projects_all p,
346: gms_project_types gpt
347: where a.invoice_id = p_invoice_id
348: and a.project_id = p.project_id
349: and a.award_id is not NULL
350: and p.project_type = gpt.project_type