APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_PLANS

Line 223: msc_plans p

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

Line 381: FROM msc_plans p,

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

Line 519: FROM msc_plans p,

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

Line 670: FROM msc_plans p,

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

Line 797: FROM msc_plans p,

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

Line 1017: from msc_plans

1013:
1014: --dbms_output.put_line('At 1');
1015: select compile_designator,curr_plan_type
1016: into p_designator,l_plan_type
1017: from msc_plans
1018: where plan_id = p_plan_id;
1019:
1020: log_message('Designator/Plan Type : ' || p_designator || '/' || l_plan_type );
1021:

Line 2507: FROM msc_plans

2503: IF (t_pub_id is not null and t_pub_id.COUNT >0 and p_type = PROJECTED_AVAILABLE_BALANCE) THEN
2504:
2505: SELECT plan_start_date
2506: INTO l_plan_start_date
2507: FROM msc_plans
2508: WHERE plan_id = p_plan_id;
2509:
2510: FOR j in 1..t_pub_id.COUNT LOOP
2511: