APPS.OZF_SCHEDULE_DENORM_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 226: ams_campaign_schedules_b s,

222: decode(ap.inventory_item_id, null, ap.category_id,ap.inventory_item_id) item,
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

Line 727: FROM ams_campaign_schedules_b b

723: ozf_utility_pvt.write_conc_log('-- Update the status in the ozf_activity_hl_denorm table from Campaign Schedules --'|| '-'||to_char(sysdate,'dd-mon-yyy-hh:mi:ss'));
724: update ozf_activity_hl_denorm h
725: set (h.schedule_status,h.schedule_update_date) =
726: (SELECT b.status_code,sysdate
727: FROM ams_campaign_schedules_b b
728: WHERE b.schedule_id = h.schedule_id
729: AND b.last_update_date > l_latest_comp_date
730: AND b.creation_date < l_latest_comp_date);
731:

Line 773: ams_campaign_schedules_b s,

769: i.rollup_type, i.campaign_type, i.campaign_name,i.private_flag,
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