APPS.OZF_SCHEDULE_DENORM_PVT dependencies on AMS_ACT_PRODUCTS

Line 193: ams_act_products ap,

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
197: am.schedule_id = s.schedule_id

Line 227: ams_act_products ap,

223: ap.level_type_code item_type, al.list_header_id,s.custom_setup_id,
224: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id
225: FROM
226: ams_campaign_schedules_b s,
227: ams_act_products ap,
228: ams_act_lists al
229: WHERE
230: s.campaign_id = i.campaign_id AND
231: ap.act_product_used_by_id(+) = s.schedule_id AND

Line 354: FROM ozf_activity_hl_denorm a, ams_act_products b

350:
351:
352: CURSOR c_new_items_hl_denorm(l_latest_comp_date DATE) IS
353: SELECT activity_hl_id
354: FROM ozf_activity_hl_denorm a, ams_act_products b
355: WHERE a.schedule_id = b.act_product_used_by_id
356: AND b.arc_act_product_used_by = 'CSCH'
357: AND b.creation_date > l_latest_comp_date;
358:

Line 392: FROM ams_act_products

388: SELECT 'Y'
389: FROM DUAL
390: WHERE EXISTS (
391: SELECT 1
392: FROM ams_act_products
393: WHERE inventory_item_id = l_item_id
394: AND act_product_used_by_id = l_schedule_id
395: AND arc_act_product_used_by = 'CSCH'
396: AND level_type_code = 'PRODUCT'

Line 404: FROM ams_act_products

400: SELECT 'Y'
401: FROM DUAL
402: WHERE EXISTS (
403: SELECT 1
404: FROM ams_act_products
405: WHERE category_id = l_category_id
406: AND act_product_used_by_id = l_schedule_id
407: AND arc_act_product_used_by = 'CSCH'
408: AND level_type_code = 'FAMILY'

Line 517: ams_act_products ap

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
521: ap.act_product_used_by_id = s.schedule_id AND

Line 534: ams_act_products ap,

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

Line 687: FROM ozf_activity_hl_denorm a, ams_act_products b

683: Campaign_type,Campaign_name,confidential_flag,Item,Item_type,List_header_id,
684: Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login,product_update_date)
685: SELECT ozf_activity_hl_denorm_s.nextval, Schedule_Id, Campaign_id, Campaign_status, Campaign_class, Campaign_type,
686: Campaign_name, confidential_flag,Item, Item_type, List_header_id,sysdate,null,sysdate,null,null,sysdate
687: FROM ozf_activity_hl_denorm a, ams_act_products b
688: WHERE a.schedule_id = b.act_product_used_by_id
689: AND b.arc_act_product_used_by = 'CSCH'
690: AND b.creation_date > l_latest_comp_date;
691:

Line 774: ams_act_products ap,

770: decode(ap.inventory_item_id, null, ap.category_id,ap.inventory_item_id) item,
771: ap.level_type_code item_type, al.list_header_id,sysdate,null,sysdate,null,null,sysdate
772: FROM
773: ams_campaign_schedules_b s,
774: ams_act_products ap,
775: ams_act_lists al
776: WHERE
777: s.campaign_id = i.campaign_id AND
778: s.creation_date > l_latest_comp_date and