APPS.MSC_PQ_UTILS dependencies on MSC_PLANS

Line 42: FROM msc_plans

38: l_plan_type number;
39:
40: CURSOR c_plan_type(v_plan_id NUMBER) IS
41: SELECT curr_plan_type
42: FROM msc_plans
43: WHERE plan_id = v_plan_id;
44: BEGIN
45: OPEN c_plan_type(p_plan_id);
46: FETCH c_plan_type INTO l_plan_type;

Line 226: msc_plans mp

222: --,nvl(sup.new_ship_date,sup.new_schedule_date) new_due_date
223: FROM msc_supplies sup,
224: msc_system_items msi ,
225: msc_item_categories mic,
226: msc_plans mp
227: WHERE mic.sr_instance_id = sup.sr_instance_id
228: AND mic.organization_id = sup.organization_id
229: AND mic.inventory_item_id = sup.inventory_item_id
230: AND

Line 257: msc_plans mp,

253: p_to_date IN DATE ) IS
254: SELECT dem.demand_id transaction_id
255: --,nvl(dem.planned_inbound_due_date , dem.using_assembly_demand_date) new_due_date
256: FROM msc_demands dem,
257: msc_plans mp,
258: msc_system_items msi ,
259: msc_item_categories mic
260: WHERE mic.sr_instance_id = dem.sr_instance_id
261: AND mic.organization_id = dem.organization_id

Line 294: msc_plans mp,

290: p_to_date IN DATE ) IS
291: SELECT dem.demand_id transaction_id
292: --,nvl(dem.old_using_assembly_demand_date , dem.using_assembly_demand_date) new_due_date
293: FROM msc_demands dem,
294: msc_plans mp,
295: msc_system_items msi ,
296: msc_item_categories mic
297: WHERE mic.sr_instance_id = dem.sr_instance_id
298: AND mic.organization_id = dem.organization_id

Line 1976: FROM msc_plans

1972: test BOOLEAN;
1973:
1974: CURSOR c_plans IS
1975: SELECT compile_designator
1976: FROM msc_plans
1977: WHERE plan_id = -1;
1978:
1979: l_plan VARCHAR2(30);
1980: l_query_type_temp NUMBER;

Line 2254: FROM msc_plans

2250: -- and
2251:
2252: CURSOR check_release_method IS
2253: SELECT AUTO_RELEASE_METHOD
2254: FROM msc_plans
2255: WHERE plan_id = p_plan_Id;
2256:
2257: TYPE r_cursor is REF CURSOR;
2258: t_cur r_cursor;

Line 3440: SELECT COMPILE_DESIGNATOR INTO plan_name FROM MSC_PLANS WHERE plan_id=l_plan_id;

3436: BEGIN
3437:
3438: IF l_plan_id >0 THEN
3439: BEGIN
3440: SELECT COMPILE_DESIGNATOR INTO plan_name FROM MSC_PLANS WHERE plan_id=l_plan_id;
3441: EXCEPTION
3442: WHEN OTHERS THEN
3443: plan_name:=NULL;
3444: l_return_code:=l_return_code||' Error getting plan name for plan id: '||l_plan_id ||SQLERRM;