APPS.MSC_X_NETTING4_PKG dependencies on MSC_SUP_DEM_HISTORY

Line 48: FROM msc_sup_dem_history sdh

44: AND (sd.last_update_login is NULL OR nvl(sd.last_update_login,-99) <>-99) --added for Bug #6729356
45: AND NOT EXISTS ---- Fix for Bug # 6144881
46: (
47: SELECT order_number
48: FROM msc_sup_dem_history sdh
49: WHERE sdh.quantity_old is null
50: AND sdh.order_number = sd.order_number
51: AND nvl(sdh.line_number, -99) = nvl(sd.line_number, -99)
52: AND nvl(sdh.release_number,-99) = nvl(sd.release_number, -99)

Line 93: msc_sup_dem_history sd2

89: sd1.key_date,
90: sd2.key_date_new,
91: sd2.key_date_old
92: FROM msc_sup_dem_entries sd1,
93: msc_sup_dem_history sd2
94: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
95: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
96: AND sd2.plan_id = sd1.plan_id
97: AND sd2.publisher_order_type = sd1.publisher_order_type

Line 140: msc_sup_dem_history sd2

136: sd1.key_date,
137: sd2.key_date_new,
138: sd2.key_date_old
139: FROM msc_sup_dem_entries sd1,
140: msc_sup_dem_history sd2
141: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
142: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
143: AND sd2.plan_id = sd1.plan_id
144: AND sd2.publisher_order_type = sd1.publisher_order_type

Line 603: FROM msc_sup_dem_history sd1,

599: sd2.supplier_site_id,
600: sd1.supplier_site_name,
601: sd1.supplier_item_name,
602: sd1.supplier_item_description
603: FROM msc_sup_dem_history sd1,
604: msc_sup_dem_entries sd2,
605: msc_item_suppliers itm,
606: msc_trading_partners part,
607: msc_trading_partner_maps map

Line 3379: FROM msc_sup_dem_history sd

3375:
3376:
3377: SELECT count(*)
3378: INTO l_stock_out
3379: FROM msc_sup_dem_history sd
3380: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
3381: AND sd.publisher_order_type = msc_x_netting_pkg.ALLOCATED_ONHAND
3382: AND sd.publisher_name = b_publisher_name(j)
3383: AND sd.publisher_site_name = b_publisher_site_name(j)