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_OIE_INT_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 333: ap_expense_report_lines_all aerl,

329: null, -- rlmi_id
330: null -- bud_task_id
331: from ap_invoice_distributions_all aid,
332: ap_expense_report_headers_all aerh,
333: ap_expense_report_lines_all aerl,
334: gms_project_types gpt,
335: pa_projects_all pp
336: where aerh.vouchno = aid.invoice_id
337: and aerh.report_header_id = aerl.report_header_id

Line 368: ap_expense_report_lines_all aerl,

364:
365: select aeh.report_header_id, aerl.project_id bulk collect
366: into cur_report_header_id, cur_project_id
367: from ap_expense_report_headers_all aeh,
368: ap_expense_report_lines_all aerl,
369: pa_projects_all pp, gms_project_types gpt
370: where aeh.report_header_id = aerl.report_header_id
371: and aeh.vouchno = p_invoice_id(i)
372: and aerl.project_id = pp.project_id

Line 382: update ap_expense_report_lines_all aerl

378: if cur_project_id.COUNT > 0 then
379:
380: forall i in cur_project_id.FIRST..cur_project_id.LAST
381:
382: update ap_expense_report_lines_all aerl
383: set (award_id, award_number) = (select aw.award_id, aw.award_number
384: from gms_awards_all aw, gms_award_distributions adl
385: where aw.award_id = adl.award_id
386: and adl.expenditure_item_id = aerl.reference_1