APPS.MSC_X_EX5_PKG dependencies on MSC_ITEM_SUPPLIERS

Line 94: msc_item_suppliers itm,

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
98: WHERE sd.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID

Line 127: FROM msc_item_suppliers itm,

123: itm.organization_id,
124: itm.supplier_id,
125: itm.supplier_site_id,
126: itm.sr_instance_id
127: FROM msc_item_suppliers itm,
128: msc_trading_partners tp2 ,
129: msc_trading_partner_sites tps,
130: MSC_X_ITEM_SUPPLIERS_GTT iut,
131: MSC_X_ITEM_ORGS_GTT iot,

Line 149: msc_item_suppliers itm,

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
153: WHERE sd.plan_id = -1

Line 190: msc_item_suppliers itm,

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
194: WHERE sd.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID

Line 366: FROM msc_item_suppliers itm

362: , itm.fixed_order_quantity
363: , mvt.average_daily_demand
364: , itm.vmi_refresh_flag
365: , itm.replenishment_method
366: FROM msc_item_suppliers itm
367: , msc_vmi_temp mvt
368: WHERE itm.inventory_item_id = p_inventory_item_id
369: AND itm.plan_id = p_plan_id
370: AND itm.sr_instance_id = p_sr_instance_id

Line 450: FROM msc_item_suppliers itm,

446: tps.TP_SITE_CODE ,
447: msi.item_name,
448: msi.description,
449: itm.supplier_item_name
450: FROM msc_item_suppliers itm,
451: msc_trading_partners tp ,
452: msc_trading_partners tp2 ,
453: msc_trading_partner_sites tps ,
454: msc_system_items msi