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_SOURCE_CODES

Line 364: ams_source_codes a,

360: when b.actual_exec_end_date < g_start_date then null
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

Line 420: ams_source_codes a,

416: DECODE(c.start_date_time,null,null,b.actual_exec_end_date),
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,

Line 426: ams_source_codes s

422: ams_campaign_schedules_b c,
423: jtf_loc_hierarchies_b d,
424: jtf_loc_hierarchies_b d2,
425: bis_territory_hierarchies t,
426: ams_source_codes s
427: WHERE
428: a.source_code = c.source_code
429: AND a.source_code_for_id = c.schedule_id
430: AND a.arc_source_code_for = 'CSCH'

Line 480: ams_source_codes a,

476: when b.active_to_date < g_start_date then null
477: else b.active_to_date end adj_end_date,
478: b.last_update_date obj_last_update_date
479: FROM
480: ams_source_codes a,
481: ams_event_headers_all_b b,
482: jtf_loc_hierarchies_b d,
483: bis_territory_hierarchies t
484: WHERE

Line 534: ams_source_codes a,

530: DECODE(c.event_start_date,null,null,b.active_to_date),
531: c.event_end_date),'DD/MM/RRRR') end adj_end_date,
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,

Line 540: ams_source_codes s

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
541: WHERE
542: a.source_code = c.source_code
543: AND a.source_code_for_id = c.event_offer_id
544: AND a.arc_source_code_for= 'EVEO'

Line 591: FROM ams_source_codes a,

587: case
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

Line 958: ams_source_codes a,

954: when b.actual_exec_end_date < g_start_date then null
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

Line 1014: ams_source_codes a,

1010: DECODE(c.start_date_time,null,null,b.actual_exec_end_date),
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,

Line 1020: ams_source_codes s

1016: ams_campaign_schedules_b c,
1017: jtf_loc_hierarchies_b d,
1018: jtf_loc_hierarchies_b d2,
1019: bis_territory_hierarchies t,
1020: ams_source_codes s
1021: WHERE
1022: ((c.last_update_date between p_start_date and p_end_date and c.start_date_time <= p_start_date) or (c.start_date_time between p_start_date and p_end_date))
1023: AND a.source_code = c.source_code
1024: AND a.source_code_for_id = c.schedule_id

Line 1074: ams_source_codes a,

1070: when b.active_to_date < g_start_date then null
1071: else b.active_to_date end adj_end_date,
1072: b.last_update_date obj_last_update_date
1073: FROM
1074: ams_source_codes a,
1075: ams_event_headers_all_b b,
1076: jtf_loc_hierarchies_b d,
1077: bis_territory_hierarchies t
1078: WHERE

Line 1128: ams_source_codes a,

1124: DECODE(c.event_start_date,null,null,b.active_to_date),
1125: c.event_end_date),'DD/MM/RRRR') end adj_end_date,
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,

Line 1134: ams_source_codes s

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
1135: WHERE
1136: ((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))
1137: AND a.source_code = c.source_code
1138: AND a.source_code_for_id = c.event_offer_id

Line 1185: FROM ams_source_codes a,

1181: case
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