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 JTF_LOC_HIERARCHIES_B

Line 366: jtf_loc_hierarchies_b d,

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
370: AND a.source_code_for_id = b.campaign_id

Line 423: jtf_loc_hierarchies_b d,

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,
426: ams_source_codes s
427: WHERE

Line 424: jtf_loc_hierarchies_b d2,

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,
426: ams_source_codes s
427: WHERE
428: a.source_code = c.source_code

Line 482: jtf_loc_hierarchies_b d,

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
485: a.source_code = b.source_code
486: AND a.source_code_for_id = b.event_header_id

Line 537: jtf_loc_hierarchies_b d,

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
541: WHERE

Line 538: jtf_loc_hierarchies_b d2,

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
541: WHERE
542: a.source_code = c.source_code

Line 593: jtf_loc_hierarchies_b d,

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
597: AND a.arc_source_code_for ='EONE'

Line 641: jtf_loc_hierarchies_b d,

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
645: AND b.city_id = d.location_hierarchy_id

Line 960: jtf_loc_hierarchies_b d,

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))
964: AND a.source_code = b.source_code

Line 1017: jtf_loc_hierarchies_b d,

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,
1020: ams_source_codes s
1021: WHERE

Line 1018: jtf_loc_hierarchies_b d2,

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,
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))

Line 1076: jtf_loc_hierarchies_b d,

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
1079: ((b.last_update_date between p_start_date and p_end_date and b.active_from_date <= p_start_date) or (b.active_from_date between p_start_date and p_end_date))
1080: AND a.source_code = b.source_code

Line 1131: jtf_loc_hierarchies_b d,

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
1135: WHERE

Line 1132: jtf_loc_hierarchies_b d2,

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
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))

Line 1187: jtf_loc_hierarchies_b d,

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))
1191: AND a.source_code = c.source_code

Line 1236: jtf_loc_hierarchies_b d,

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))
1240: AND b.city_id = d.location_hierarchy_id