APPS.MSC_X_EX5_PKG dependencies on MSC_SUP_DEM_ENTRIES_V

Line 93: FROM msc_sup_dem_entries_v sd,

89: itm.organization_id,
90: itm.supplier_id,
91: itm.supplier_site_id,
92: itm.sr_instance_id
93: FROM msc_sup_dem_entries_v sd,
94: msc_item_suppliers itm,
95: MSC_X_ITEM_SUPPLIERS_GTT iut,
96: MSC_X_ITEM_ORGS_GTT iot,
97: MSC_X_ITEM_SITES_GTT ist

Line 148: FROM msc_sup_dem_entries_v sd,

144: --and ( itm.supplier_site_id is not null or rownum = 1)
145: AND itm.vmi_flag = 1
146: AND NVL(itm.enable_vmi_auto_replenish_flag, 'N') = 'N'
147: AND itm.inventory_item_id NOT IN ( select distinct sd.inventory_item_id
148: FROM msc_sup_dem_entries_v sd,
149: msc_item_suppliers itm,
150: MSC_X_ITEM_SUPPLIERS_GTT iut,
151: MSC_X_ITEM_ORGS_GTT iot,
152: MSC_X_ITEM_SITES_GTT ist

Line 189: FROM msc_sup_dem_entries_v sd,

185: itm.organization_id,
186: itm.supplier_id,
187: itm.supplier_site_id,
188: itm.sr_instance_id
189: FROM msc_sup_dem_entries_v sd,
190: msc_item_suppliers itm,
191: MSC_X_ITEM_SUPPLIERS_GTT iut,
192: MSC_X_ITEM_ORGS_GTT iot,
193: MSC_X_ITEM_SITES_GTT ist

Line 400: FROM msc_sup_dem_entries_v sd

396: sd.supplier_site_name,
397: sd.item_name,
398: sd.item_description,
399: sd.supplier_item_name
400: FROM msc_sup_dem_entries_v sd
401: WHERE sd.inventory_item_id = p_inventory_item_id
402: AND sd.plan_id = p_plan_id
403: AND sd.customer_site_id = p_organization_id
404: AND sd.supplier_id = p_supplier_id

Line 425: FROM msc_sup_dem_entries_v sd

421: sd.customer_site_name,
422: sd.item_name,
423: sd.item_description,
424: sd.customer_item_name
425: FROM msc_sup_dem_entries_v sd
426: WHERE sd.inventory_item_id = p_inventory_item_id
427: AND sd.plan_id = p_plan_id
428: AND sd.customer_site_id = p_organization_id
429: AND sd.supplier_id = p_supplier_id