APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_PLAN_BUCKETS

Line 160: l_bucket_end_date msc_plan_buckets.bkt_end_date%type;

156: i_bkt_type numberList;
157:
158:
159: i number;
160: l_bucket_end_date msc_plan_buckets.bkt_end_date%type;
161: l_bucket_type msc_plan_buckets.bucket_type%type;
162: l_supply number;
163: l_demand number;
164: l_scrap_demand number;

Line 161: l_bucket_type msc_plan_buckets.bucket_type%type;

157:
158:
159: i number;
160: l_bucket_end_date msc_plan_buckets.bkt_end_date%type;
161: l_bucket_type msc_plan_buckets.bucket_type%type;
162: l_supply number;
163: l_demand number;
164: l_scrap_demand number;
165: l_exp_lot number;

Line 213: msc_plan_buckets mpb,

209: NULL, --mst.project_id,
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,

Line 287: FROM msc_plan_buckets mpb,

283: p_org_id in number,
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

Line 382: msc_plan_buckets mpb,

378: FROM msc_plans p,
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,

Line 520: msc_plan_buckets mpb,

516: FROM msc_plans p,
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,

Line 608: There will be no join to msc_plan_buckets.

604: Bug# 3893860
605: The following 2 select statement are added for the fix. The
606: fix will include the past due pab calculation
607: That means will include all the data before the plan_start_date.
608: There will be no join to msc_plan_buckets.
609: ----------------------------------------------------------------------*/
610: SELECT rec.sr_instance_id,
611: rec.organization_id,
612: msi.base_item_id,

Line 1885: FROM msc_plan_buckets mpb ,

1881: p_org_id in number,
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