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 216: msc_plan_buckets mpb,

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

Line 290: FROM msc_plan_buckets mpb,

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

Line 385: msc_plan_buckets mpb,

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

Line 523: msc_plan_buckets mpb,

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

Line 611: There will be no join to msc_plan_buckets.

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

Line 1901: FROM msc_plan_buckets mpb ,

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