DBA Data[Home] [Help]

APPS.MSC_X_RECEIVE_CAPACITY_PKG dependencies on MSC_SUP_DEM_ENTRIES_V

Line 42: FROM msc_sup_dem_entries_v sd,

38: --mis.DELIVERY_CALENDAR_CODE,
39: map2.tp_key, -- supplier_aps_id
40: map3.tp_key, -- supplier_site aps id
41: item1.ROUNDING_CONTROL_TYPE
42: FROM msc_sup_dem_entries_v sd,
43: msc_trading_partner_maps map1,
44: msc_trading_partners tp,
45: msc_system_items item,
46: msc_company_relationships cr,

Line 118: FROM msc_sup_dem_entries_v sd,

114: --mis.DELIVERY_CALENDAR_CODE,
115: map2.tp_key,
116: map3.tp_key,
117: item1.ROUNDING_CONTROL_TYPE
118: FROM msc_sup_dem_entries_v sd,
119: msc_trading_partner_maps map1,
120: msc_trading_partners tp,
121: msc_system_items item,
122: MSC_CAL_WEEK_START_DATES mcd,

Line 202: FROM msc_sup_dem_entries_v sd,

198: --mis.DELIVERY_CALENDAR_CODE,
199: map2.tp_key,
200: map3.tp_key,
201: item1.ROUNDING_CONTROL_TYPE
202: FROM msc_sup_dem_entries_v sd,
203: msc_trading_partner_maps map1,
204: msc_trading_partners tp,
205: msc_system_items item,
206: MSC_PERIOD_START_DATES mpd,

Line 273: FROM msc_sup_dem_entries_v sd,

269: p_sce_supplier_id IN NUMBER,
270: p_sce_supplier_site_id IN NUMBER,
271: p_bucket_type IN NUMBER) IS
272: SELECT sum(sd.tp_quantity)
273: FROM msc_sup_dem_entries_v sd,
274: msc_trading_partner_maps map1,
275: msc_trading_partners tp,
276: msc_system_items item
277: WHERE sd.plan_id = -1