APPS.OZF_SCHEDULE_DENORM_PVT dependencies on AMS_CAMPAIGNS_VL

Line 45: ams_campaigns_vl ct,

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,
48: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu,hz_locations hl, hz_party_sites hp
49: WHERE

Line 97: ams_campaigns_vl ct,

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

Line 144: ams_campaigns_vl ct,

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

Line 163: ams_campaigns_vl c

159: CURSOR c_all_campaigns IS
160: SELECT c.campaign_id, c.status_code, c.rollup_type, c.campaign_type,
161: c.campaign_name,c.private_flag
162: FROM
163: ams_campaigns_vl c
164: WHERE
165: c.status_code in ('ACTIVE', 'AVAILABLE', 'COMPLETED', 'PENDINGAPPROVAL');
166:
167:

Line 178: ams_campaigns_vl ct

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;
182:

Line 192: ams_campaigns_vl ct,

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

Line 451: ams_campaigns_vl ct,

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
455: s.schedule_id = l_schedule_id

Line 476: ams_campaigns_vl ct,

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
480: s.schedule_id = l_schedule_id

Line 496: ams_campaigns_vl ct,

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
500: s.schedule_id = l_schedule_id

Line 516: ams_campaigns_vl ct,

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
520: ct.campaign_id = s.campaign_id and

Line 533: ams_campaigns_vl ct,

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

Line 551: ams_campaigns_vl c

547:
548: CURSOR c_incr_campaigns IS
549: SELECT c.campaign_id, c.status_code, c.rollup_type, c.campaign_type, c.campaign_name,c.private_flag
550: FROM
551: ams_campaigns_vl c
552: WHERE
553: c.status_code in ('ACTIVE', 'AVAILABLE', 'COMPLETED', 'PENDINGAPPROVAL');
554:
555: l_api_version CONSTANT NUMBER := 1.0;