APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_PLAN_ORGANIZATIONS_V

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