[Home] [Help]
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
371: AND b.city_id = d.location_hierarchy_id
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
429: AND a.source_code_for_id = c.schedule_id
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
487: AND b.country_code = d.location_hierarchy_id
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
543: AND a.source_code_for_id = c.event_offer_id
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'
598: AND nvl(c.parent_type,'N') <> 'CAMP'
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
646: AND t.parent_territory_type(+) = 'AREA'
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
965: AND a.source_code_for_id = b.campaign_id
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))
1023: AND a.source_code = c.source_code
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
1081: AND a.source_code_for_id = b.event_header_id
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))
1137: AND a.source_code = c.source_code
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
1192: AND a.source_code_for_id = c.event_offer_id
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
1241: AND t.parent_territory_type(+) = 'AREA'