APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_PLAN_ORGANIZATIONS

Line 217: msc_plan_organizations_v ov,

213: NULL, --mst.task_id,
214: sum(mst.safety_stock_quantity)
215: FROM msc_safety_stocks mst,
216: msc_plan_buckets mpb,
217: msc_plan_organizations_v ov,
218: msc_system_items item,
219: msc_companies c,
220: msc_company_sites s,
221: msc_trading_partners t,

Line 291: msc_plan_organizations_v ov -- Bug# 3913477

287: p_horizon_start_date in date,
288: p_horizon_end_date in date) IS
289: SELECT mpb.bucket_index, mpb.bkt_start_date, mpb.bkt_end_date, mpb.bucket_type
290: FROM msc_plan_buckets mpb,
291: msc_plan_organizations_v ov -- Bug# 3913477
292: WHERE ov.plan_id = p_plan_id
293: AND ov.sr_instance_id = p_sr_instance_id
294: AND ov.planned_organization = p_org_id
295: and mpb.plan_id = ov.plan_id

Line 386: msc_plan_organizations_v ov,

382: msc_trading_partners param,
383: msc_system_items msi,
384: msc_supplies rec,
385: msc_plan_buckets mpb,
386: msc_plan_organizations_v ov,
387: msc_companies c,
388: msc_company_sites s,
389: msc_trading_partners t,
390: msc_trading_partner_maps m

Line 524: msc_plan_organizations_v ov,

520: msc_trading_partners param,
521: msc_system_items msi,
522: msc_demands mgr,
523: msc_plan_buckets mpb,
524: msc_plan_organizations_v ov,
525: msc_companies c,
526: msc_company_sites s,
527: msc_trading_partners t,
528: msc_trading_partner_maps m

Line 1902: msc_plan_organizations_v ov -- Bug# 3913477

1898: p_start_date in date,
1899: p_end_date in date) IS
1900: SELECT mpb.bucket_index, trunc(mpb.bkt_start_date), trunc(mpb.bkt_end_date), mpb.bucket_type
1901: FROM msc_plan_buckets mpb ,
1902: msc_plan_organizations_v ov -- Bug# 3913477
1903: WHERE ov.plan_id = p_plan_id
1904: AND ov.sr_instance_id = p_sr_instance_id
1905: AND ov.planned_organization = p_org_id
1906: AND mpb.plan_id = ov.plan_id

Line 3326: from msc_plan_organizations o,

3322: where sd.publisher_order_type in (SAFETY_STOCK, PROJECTED_AVAILABLE_BALANCE) and
3323: sd.plan_id = -1 and
3324: sd.publisher_id = 1 and
3325: exists (select cs.company_site_id
3326: from msc_plan_organizations o,
3327: msc_company_sites cs,
3328: msc_trading_partner_maps m,
3329: msc_trading_partners p
3330: where o.plan_id = p_plan_id and

Line 3356: from msc_plan_organizations o,

3352: where sd.publisher_order_type in (SAFETY_STOCK, PROJECTED_AVAILABLE_BALANCE) and
3353: sd.plan_id = -1 and
3354: sd.publisher_id = 1 and
3355: exists (select cs.company_site_id
3356: from msc_plan_organizations o,
3357: msc_company_sites cs,
3358: msc_trading_partner_maps m,
3359: msc_trading_partners p
3360: where o.plan_id = p_plan_id and