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_CAMPAIGNS_ALL_B

Line 365: ams_campaigns_all_b b,

361: else b.actual_exec_end_date end adj_end_date,
362: b.last_update_date obj_last_update_date
363: FROM
364: ams_source_codes a,
365: ams_campaigns_all_b b,
366: jtf_loc_hierarchies_b d,
367: bis_territory_hierarchies t
368: WHERE
369: a.source_code = b.source_code

Line 421: ams_campaigns_all_b b,

417: c.end_date_time),'DD/MM/RRRR') end adj_end_date,
418: c.last_update_date obj_last_update_date
419: FROM
420: ams_source_codes a,
421: ams_campaigns_all_b b,
422: ams_campaign_schedules_b c,
423: jtf_loc_hierarchies_b d,
424: jtf_loc_hierarchies_b d2,
425: bis_territory_hierarchies t,

Line 640: ams_campaigns_all_b b,

636: when b.actual_exec_end_date < g_start_date then null
637: else b.actual_exec_end_date end adj_end_date,
638: b.last_update_date obj_last_update_date
639: FROM
640: ams_campaigns_all_b b,
641: jtf_loc_hierarchies_b d,
642: bis_territory_hierarchies t
643: WHERE
644: b.actual_exec_start_date <= p_end_date

Line 959: ams_campaigns_all_b b,

955: else b.actual_exec_end_date end adj_end_date,
956: b.last_update_date obj_last_update_date
957: FROM
958: ams_source_codes a,
959: ams_campaigns_all_b b,
960: jtf_loc_hierarchies_b d,
961: bis_territory_hierarchies t
962: WHERE
963: ((b.last_update_date between p_start_date and p_end_date and b.actual_exec_start_date <= p_start_date) or ( b.actual_exec_start_date between p_start_date and p_end_date))

Line 1015: ams_campaigns_all_b b,

1011: c.end_date_time),'DD/MM/RRRR') end adj_end_date,
1012: c.last_update_date obj_last_update_date
1013: FROM
1014: ams_source_codes a,
1015: ams_campaigns_all_b b,
1016: ams_campaign_schedules_b c,
1017: jtf_loc_hierarchies_b d,
1018: jtf_loc_hierarchies_b d2,
1019: bis_territory_hierarchies t,

Line 1235: ams_campaigns_all_b b,

1231: when b.actual_exec_end_date < g_start_date then null
1232: else b.actual_exec_end_date end adj_end_date,
1233: b.last_update_date obj_last_update_date
1234: FROM
1235: ams_campaigns_all_b b,
1236: jtf_loc_hierarchies_b d,
1237: bis_territory_hierarchies t
1238: WHERE
1239: ((b.last_update_date between p_start_date and p_end_date and b.actual_exec_start_date <= p_start_date) or (b.actual_exec_start_date between p_start_date and p_end_date))