DBA Data[Home] [Help]

APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on MSD_DEMAND_PLANS

Line 36: FROM msd_demand_plans

32: ORDER BY created DESC;
33:
34: CURSOR check_srp_plan IS
35: SELECT demand_plan_id
36: FROM msd_demand_plans
37: WHERE demand_plan_id = 5555555;
38:
39: CURSOR get_scn_id IS
40: SELECT scenario_id

Line 270: INTO msd_demand_plans(demand_plan_id, organization_id, demand_plan_name, last_update_date, last_updated_by, creation_date, created_by, sr_instance_id, use_org_specific_bom_flag)

266:
267: IF l_demand_plan_id IS NULL THEN
268:
269: INSERT
270: INTO msd_demand_plans(demand_plan_id, organization_id, demand_plan_name, last_update_date, last_updated_by, creation_date, created_by, sr_instance_id, use_org_specific_bom_flag)
271: VALUES(5555555, -23453, 'SRP DUMMY PLAN', trunc(sysdate), fnd_global.user_id, trunc(sysdate), fnd_global.user_id, -23453, 'N');
272:
273: END IF;
274: