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.AP_WEB_CUST_AME_PKG dependencies on AP_EXP_REPORT_DISTS_ALL

Line 129: from ap_exp_report_dists_all dist

125: -----------------------------------------------------
126: select count(distinct award_id), count(distinct nvl(award_id, -1)),
127: count(distinct project_id), count(distinct nvl(project_id, -1))
128: into l_num_of_distinct_awards, l_num_of_awards, l_num_of_distinct_projects, l_num_of_projects
129: from ap_exp_report_dists_all dist
130: where report_header_id = p_report_header_id
131: and report_line_id not in (
132: select report_line_id
133: from ap_expense_report_lines_all line

Line 143: from ap_exp_report_dists_all dist

139: -----------------------------------------------------
140: IF (l_num_of_distinct_awards = 1 AND l_num_of_awards = 1) THEN
141: select distinct award_id
142: into l_award_id
143: from ap_exp_report_dists_all dist
144: where report_header_id = p_report_header_id
145: and report_line_id not in (
146: select report_line_id
147: from ap_expense_report_lines_all line

Line 172: from ap_exp_report_dists_all dist

168: -----------------------------------------------------
169: IF (l_num_of_distinct_projects = 1 AND l_num_of_projects = 1) THEN
170: select distinct project_id
171: into l_project_id
172: from ap_exp_report_dists_all dist
173: where report_header_id = p_report_header_id
174: and report_line_id not in (
175: select report_line_id
176: from ap_expense_report_lines_all line