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_I_SRC_CODE_PKG dependencies on AMS_EVENT_OFFERS_ALL_B

Line 536: ams_event_offers_all_b c,

532: c.last_update_date obj_last_update_date
533: FROM
534: ams_source_codes a,
535: ams_event_headers_all_b b,
536: ams_event_offers_all_b c,
537: jtf_loc_hierarchies_b d,
538: jtf_loc_hierarchies_b d2,
539: bis_territory_hierarchies t ,
540: ams_source_codes s

Line 592: ams_event_offers_all_b c,

588: when c.event_end_date < g_start_date then null
589: else c.event_end_date end adj_end_date,
590: c.last_update_date obj_last_update_date
591: FROM ams_source_codes a,
592: ams_event_offers_all_b c,
593: jtf_loc_hierarchies_b d,
594: bis_territory_hierarchies t
595: WHERE a.source_code = c.source_code
596: AND a.source_code_for_id = c.event_offer_id

Line 1130: ams_event_offers_all_b c,

1126: c.last_update_date obj_last_update_date
1127: FROM
1128: ams_source_codes a,
1129: ams_event_headers_all_b b,
1130: ams_event_offers_all_b c,
1131: jtf_loc_hierarchies_b d,
1132: jtf_loc_hierarchies_b d2,
1133: bis_territory_hierarchies t,
1134: ams_source_codes s

Line 1186: ams_event_offers_all_b c,

1182: when c.event_end_date < g_start_date then null
1183: else c.event_end_date end adj_end_date,
1184: c.last_update_date obj_last_update_date
1185: FROM ams_source_codes a,
1186: ams_event_offers_all_b c,
1187: jtf_loc_hierarchies_b d,
1188: bis_territory_hierarchies t
1189: WHERE
1190: ((c.last_update_date between p_start_date and p_end_date and c.event_start_date <= p_start_date) or (c.event_start_date between p_start_date and p_end_date))