APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_PLANS

Line 220: msc_plans p

216: msc_companies c,
217: msc_company_sites s,
218: msc_trading_partners t,
219: msc_trading_partner_maps m,
220: msc_plans p
221: WHERE p.plan_id = mst.plan_id
222: and mst.plan_id = p_plan_id
223: and mst.organization_id = nvl(p_org_id, mst.organization_id)
224: and mst.sr_instance_id = nvl(p_sr_instance_id, mst.sr_instance_id)

Line 378: FROM msc_plans p,

374: NULL, rec.new_order_quantity, rec.daily_rate) *
375: DECODE(rec.order_type, DIS_JOB_BY, -1, NON_ST_JOB_BY, -1,
376: REP_SCHED_BY, -1, PLANNED_BY, -1,
377: FLOW_SCHED_BY, -1, 1))) new_quantity
378: FROM msc_plans p,
379: msc_trading_partners param,
380: msc_system_items msi,
381: msc_supplies rec,
382: msc_plan_buckets mpb,

Line 516: FROM msc_plans p,

512: 0,1,
513: nvl(LEAST(SUM(DECODE(mgr.origination_type,
514: 29,nvl(mgr.probability,0),
515: null)) ,1) ,1)) new_quantity
516: FROM msc_plans p,
517: msc_trading_partners param,
518: msc_system_items msi,
519: msc_demands mgr,
520: msc_plan_buckets mpb,

Line 667: FROM msc_plans p,

663: NULL, rec.new_order_quantity, rec.daily_rate) *
664: DECODE(rec.order_type, DIS_JOB_BY, -1, NON_ST_JOB_BY, -1,
665: REP_SCHED_BY, -1, PLANNED_BY, -1,
666: FLOW_SCHED_BY, -1, 1))) new_quantity
667: FROM msc_plans p,
668: msc_trading_partners param,
669: msc_system_items msi,
670: msc_supplies rec,
671: msc_companies c,

Line 794: FROM msc_plans p,

790: 0,1,
791: nvl(LEAST(SUM(DECODE(mgr.origination_type,
792: 29,nvl(mgr.probability,0),
793: null)) ,1) ,1)) new_quantity
794: FROM msc_plans p,
795: msc_trading_partners param,
796: msc_system_items msi,
797: msc_demands mgr,
798: msc_companies c,

Line 1014: from msc_plans

1010:
1011: --dbms_output.put_line('At 1');
1012: select compile_designator
1013: into p_designator
1014: from msc_plans
1015: where plan_id = p_plan_id;
1016:
1017: --dbms_output.put_line('Designator : ' || p_designator);
1018:

Line 2491: FROM msc_plans

2487: IF (t_pub_id is not null and t_pub_id.COUNT >0 and p_type = PROJECTED_AVAILABLE_BALANCE) THEN
2488:
2489: SELECT plan_start_date
2490: INTO l_plan_start_date
2491: FROM msc_plans
2492: WHERE plan_id = p_plan_id;
2493:
2494: FOR j in 1..t_pub_id.COUNT LOOP
2495: