APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_PLAN_ORGANIZATIONS_V

Line 214: msc_plan_organizations_v ov,

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

Line 288: msc_plan_organizations_v ov -- Bug# 3913477

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

Line 383: msc_plan_organizations_v ov,

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

Line 521: msc_plan_organizations_v ov,

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

Line 1886: msc_plan_organizations_v ov -- Bug# 3913477

1882: p_start_date in date,
1883: p_end_date in date) IS
1884: SELECT mpb.bucket_index, trunc(mpb.bkt_start_date), trunc(mpb.bkt_end_date), mpb.bucket_type
1885: FROM msc_plan_buckets mpb ,
1886: msc_plan_organizations_v ov -- Bug# 3913477
1887: WHERE ov.plan_id = p_plan_id
1888: AND ov.sr_instance_id = p_sr_instance_id
1889: AND ov.planned_organization = p_org_id
1890: AND mpb.plan_id = ov.plan_id