APPS.MSC_X_NETTING2_PKG dependencies on MSC_PLAN_BUCKETS

Line 9: FROM msc_plan_buckets b

5:
6: --The cursor below selects the buckets generated for company/org combination
7: CURSOR time_bkts IS
8: SELECT trunc(b.bkt_start_date), trunc(b.bkt_end_date), b.bucket_type
9: FROM msc_plan_buckets b
10: WHERE b.plan_id = msc_x_netting_pkg.G_PLAN_ID;
11:
12: --================================================================
13: --Group 2: Material Shortage

Line 245: -- group the order forecast and supply commit together and join to msc_plan_buckets--

241: order by 1,2,3,4,5,6,7,8,9;
242:
243:
244: ------------------------------------------------------------------------------------------
245: -- group the order forecast and supply commit together and join to msc_plan_buckets--
246: -- this will improve the performace.
247: ------------------------------------------------------------------------------------------
248:
249: cursor get_of_sc(p_customer_id IN NUMBER,

Line 263: msc_plan_buckets bkt

259: bkt.bkt_start_date,
260: bkt.bkt_end_date,
261: msc_x_netting_pkg.ORDER_FORECAST
262: from msc_sup_dem_entries sd,
263: msc_plan_buckets bkt
264: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
265: and sd.publisher_id = p_customer_id
266: and sd.publisher_site_id = p_customer_site_id
267: and nvl(sd.base_item_id,sd.inventory_item_id) = p_item_id

Line 284: msc_plan_buckets bkt

280: bkt.bkt_start_date,
281: bkt.bkt_end_date,
282: msc_x_netting_pkg.SUPPLY_COMMIT
283: from msc_sup_dem_entries sd,
284: msc_plan_buckets bkt
285: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
286: and sd.publisher_id = p_supplier_id
287: and sd.publisher_site_id = p_supplier_site_id
288: and sd.customer_id = p_customer_id