APPS.OZF_SCHEDULE_DENORM_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 43: FROM ams_campaign_schedules_vl s,

39: cu.site_use_code,
40: decode(cu.site_use_code,'BILL_TO','QUALIFIER_ATTRIBUTE14','SHIP_TO','QUALIFIER_ATTRIBUTE11') qualifier_attribute,
41: 'CUSTOMER' qualifier_context,
42: nvl(am.item_type,'ALLPRODUCTS') prod_indicator
43: FROM ams_campaign_schedules_vl s,
44: ozf_activity_hl_denorm am,
45: ams_campaigns_vl ct,
46: ams_list_entries le,
47: hz_parties b, hz_party_sites ps,hz_locations f,

Line 96: ams_campaign_schedules_vl s,

92: decode(cu.site_use_code,'BILL_TO','QUALIFIER_ATTRIBUTE14','SHIP_TO','QUALIFIER_ATTRIBUTE11') qualifier_attribute,
93: 'CUSTOMER' qualifier_context,
94: nvl(am.item_type,'ALLPRODUCTS') prod_indicator
95: FROM ozf_activity_hl_denorm am,
96: ams_campaign_schedules_vl s,
97: ams_campaigns_vl ct,
98: ams_list_entries le,
99: hz_parties b, hz_cust_accounts ca,
100: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu, hz_relationships hr

Line 143: ams_campaign_schedules_vl s,

139: decode(cu.site_use_code,'BILL_TO','QUALIFIER_ATTRIBUTE14','SHIP_TO','QUALIFIER_ATTRIBUTE11') qualifier_attribute,
140: 'CUSTOMER' qualifier_context,
141: nvl(am.item_type,'ALLPRODUCTS') prod_indicator
142: FROM ozf_activity_hl_denorm am,
143: ams_campaign_schedules_vl s,
144: ams_campaigns_vl ct,
145: ams_list_entries le,
146: hz_parties b, hz_cust_accounts ca,
147: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu

Line 177: ams_campaign_schedules_vl s,

173: s.activity_type_code, s.activity_id, s.marketing_medium_id,am.custom_setup_id,
174: decode(am.list_header_id,null,'ALLCUSTOMERS','CUSTOMERS') cust_indicator
175: FROM
176: ozf_activity_hl_denorm am,
177: ams_campaign_schedules_vl s,
178: ams_campaigns_vl ct
179: WHERE
180: am.schedule_id = s.schedule_id
181: and ct.campaign_id = s.campaign_id;

Line 191: ams_campaign_schedules_vl s,

187: s.activity_type_code, s.activity_id, s.marketing_medium_id,am.custom_setup_id,
188: decode(am.list_header_id,null,'ALLCUSTOMERS','CUSTOMERS') cust_indicator
189: FROM
190: ozf_activity_hl_denorm am,
191: ams_campaign_schedules_vl s,
192: ams_campaigns_vl ct,
193: ams_act_products ap,
194: mtl_item_categories mtl,
195: eni_prod_denorm_hrchy_v eni

Line 450: FROM ams_campaign_schedules_vl s,

446: ct.campaign_type,ct.private_flag, s.schedule_id, 'CSCH' object_class, s.schedule_name, s.status_code,s.source_code,
447: s.start_date_time, s.end_date_time, s.owner_user_id, s.activity_type_code,
448: s.activity_id, s.marketing_medium_id, ps.party_id,cs.cust_account_id,
449: cs.cust_acct_site_id, cu.site_use_id,cu.site_use_code,nvl(l_item_type,'ALLPRODUCTS') prod_indicator
450: FROM ams_campaign_schedules_vl s,
451: ams_campaigns_vl ct,
452: hz_party_sites ps,hz_locations f,
453: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu,hz_locations hl, hz_party_sites hp
454: WHERE

Line 475: FROM ams_campaign_schedules_vl s,

471: ct.campaign_type,ct.private_flag, s.schedule_id, 'CSCH' object_class, s.schedule_name,s.status_code, s.source_code,
472: s.start_date_time, s.end_date_time, s.owner_user_id, s.activity_type_code,
473: s.activity_id, s.marketing_medium_id, hr.subject_id party_id, cs.cust_account_id,
474: cs.cust_acct_site_id, cu.site_use_id,cu.site_use_code,nvl(l_item_type,'ALLPRODUCTS') prod_indicator
475: FROM ams_campaign_schedules_vl s,
476: ams_campaigns_vl ct,
477: hz_cust_accounts ca,
478: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu, hz_relationships hr
479: WHERE

Line 495: FROM ams_campaign_schedules_vl s,

491: ct.campaign_type,ct.private_flag, s.schedule_id, 'CSCH' object_class, s.schedule_name,s.status_code, s.source_code,
492: s.start_date_time, s.end_date_time, s.owner_user_id, s.activity_type_code,
493: s.activity_id, s.marketing_medium_id, ca.party_id,cs.cust_account_id,
494: cs.cust_acct_site_id, cu.site_use_id,cu.site_use_code,nvl(l_item_type,'ALLPRODUCTS') prod_indicator
495: FROM ams_campaign_schedules_vl s,
496: ams_campaigns_vl ct,
497: hz_cust_accounts ca,
498: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu
499: WHERE

Line 515: FROM ams_campaign_schedules_vl s,

511: s.activity_id, s.marketing_medium_id,
512: decode(ap.inventory_item_id, null, ap.category_id,ap.inventory_item_id) item,
513: ap.level_type_code item_type,
514: decode(l_list_header_id,null,'ALLCUSTOMERS','CUSTOMERS') cust_indicator
515: FROM ams_campaign_schedules_vl s,
516: ams_campaigns_vl ct,
517: ams_act_products ap
518: WHERE
519: s.schedule_id = l_schedule_id AND

Line 532: FROM ams_campaign_schedules_vl s,

528: s.activity_id, s.marketing_medium_id,
529: mtl.inventory_item_id item,
530: 'PRODUCT' item_type,
531: decode(l_list_header_id,null,'ALLCUSTOMERS','CUSTOMERS') cust_indicator
532: FROM ams_campaign_schedules_vl s,
533: ams_campaigns_vl ct,
534: ams_act_products ap,
535: mtl_item_categories mtl,
536: eni_prod_denorm_hrchy_v eni