APPS.MSC_ATP_PROC dependencies on MSC_ATP_PLAN_SN

Line 2291: --msc_atp_plan_sn in this case.

2287:
2288: -- bug3510475. Check if the plan for Parent ORG /ITEM
2289: --already exists. if the parent plan exists, verify if the current
2290: --Item / Org is also planned in parent plan. Do not select from
2291: --msc_atp_plan_sn in this case.
2292: IF p_parent_plan_id is not null then
2293: BEGIN
2294: SELECT plan_id
2295: INTO x_plan_info_rec.plan_id

Line 2359: FROM msc_atp_plan_sn

2355:
2356: /*SELECT plan_id
2357: -- INTO x_plan_id commented for bug 2392456
2358: INTO x_plan_info_rec.plan_id -- changed for bug 2392456
2359: FROM msc_atp_plan_sn
2360:
2361: WHERE demand_class = p_demand_class
2362: AND sr_instance_id = p_instance_id
2363: AND organization_id = p_organization_id

Line 2371: FROM msc_atp_plan_sn

2367: SELECT plan_id
2368: INTO x_plan_info_rec.plan_id
2369: FROM
2370: (SELECT plan_id,Rank,completion_date
2371: FROM msc_atp_plan_sn
2372: WHERE demand_class = p_demand_class
2373: AND sr_instance_id = p_instance_id
2374: AND organization_id = p_organization_id
2375: AND sr_inventory_item_id = p_inventory_item_id

Line 2409: FROM msc_atp_plan_sn

2405: --2854351
2406: /*SELECT plan_id
2407: -- INTO x_plan_id commented for bug 2392456
2408: INTO x_plan_info_rec.plan_id -- changed for bug 2392456
2409: FROM msc_atp_plan_sn
2410: WHERE demand_class IS NULL
2411: AND sr_instance_id = p_instance_id
2412: AND organization_id = p_organization_id
2413: AND sr_inventory_item_id = p_inventory_item_id;

Line 2422: FROM msc_atp_plan_sn

2418: bulk collect into l_plan_ids
2419: from
2420: (
2421: SELECT plan_id,Rank,completion_date
2422: FROM msc_atp_plan_sn
2423: WHERE demand_class IS NULL
2424: AND sr_instance_id = p_instance_id
2425: AND organization_id = p_organization_id
2426: AND sr_inventory_item_id = p_inventory_item_id

Line 2431: from msc_atp_plan_sn

2427:
2428: UNION ALL
2429:
2430: SELECT -200 PLAN_ID, 20, to_date(null)
2431: from msc_atp_plan_sn
2432: WHERE rownum = 1
2433: ORDER BY Rank asc,completion_date desc,plan_id asc
2434: );
2435: