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.BIM_SOURCE_CODE_PKG dependencies on JTF_LOC_HIERARCHIES_B

Line 143: FROM jtf_loc_hierarchies_b

139: country,
140: region)
141: SELECT
142: country_code, area2_code
143: FROM jtf_loc_hierarchies_b
144: WHERE location_type_code = 'COUNTRY'
145: AND country_code is not null;
146:
147:

Line 221: jtf_loc_hierarchies_b c

217: b.actual_exec_end_date end_date
218: FROM
219: ams_source_codes a,
220: ams_campaigns_all_b b,
221: jtf_loc_hierarchies_b c
222: WHERE
223: a.source_code = b.source_code
224: AND a.source_code_for_id = b.campaign_id
225: AND b.city_id = c.location_hierarchy_id

Line 245: jtf_loc_hierarchies_b d

241: FROM
242: ams_source_codes a,
243: ams_campaigns_all_b b,
244: ams_campaign_schedules_b c,
245: jtf_loc_hierarchies_b d
246: WHERE
247: a.source_code = c.source_code
248: AND a.source_code_for_id = c.schedule_id
249: AND a.arc_source_code_for = 'CSCH'

Line 269: jtf_loc_hierarchies_b c

265: b.active_to_date end_date
266: FROM
267: ams_source_codes a,
268: ams_event_headers_all_b b,
269: jtf_loc_hierarchies_b c
270: WHERE
271: a.source_code = b.source_code
272: AND a.source_code_for_id = b.event_header_id
273: AND b.country_code = c.location_hierarchy_id

Line 293: jtf_loc_hierarchies_b d

289: FROM
290: ams_source_codes a,
291: ams_event_headers_all_b b,
292: ams_event_offers_all_b c,
293: jtf_loc_hierarchies_b d
294: WHERE
295: a.source_code = c.source_code
296: AND a.source_code_for_id = c.event_offer_id
297: AND a.arc_source_code_for in ('EONE', 'EVEO')