eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_RECEIVE_CAPACITY_PKG dependencies on MSC_SYSTEM_ITEMS

Line 45: msc_system_items item,

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,
47: msc_trading_partner_maps map2,
48: msc_trading_partner_maps map3,
49: msc_item_suppliers mis,

Line 51: msc_system_items item1

47: msc_trading_partner_maps map2,
48: msc_trading_partner_maps map3,
49: msc_item_suppliers mis,
50: msc_trading_partners tp2,
51: msc_system_items item1
52: WHERE sd.plan_id = -1
53: AND sd.publisher_order_type = SUPPLY_COMMIT
54: AND sd.bucket_Type = G_DAY
55: AND map1.tp_key = tp.partner_id

Line 121: msc_system_items item,

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,
123: msc_company_relationships cr,
124: msc_trading_partner_maps map2,
125: msc_trading_partner_maps map3,

Line 128: msc_system_items item1

124: msc_trading_partner_maps map2,
125: msc_trading_partner_maps map3,
126: msc_item_suppliers mis,
127: msc_trading_partners tp2,
128: msc_system_items item1
129: WHERE sd.plan_id = -1
130: AND sd.publisher_order_type = SUPPLY_COMMIT
131: AND sd.bucket_Type = G_WEEK
132: AND map1.tp_key = tp.partner_id

Line 205: msc_system_items item,

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,
207: msc_company_relationships cr,
208: msc_trading_partner_maps map2,
209: msc_trading_partner_maps map3,

Line 212: msc_system_items item1

208: msc_trading_partner_maps map2,
209: msc_trading_partner_maps map3,
210: msc_item_suppliers mis,
211: msc_trading_partners tp2,
212: msc_system_items item1
213: WHERE sd.plan_id = -1
214: AND sd.publisher_order_type = SUPPLY_COMMIT
215: AND sd.bucket_Type = G_MONTH
216: AND map1.tp_key = tp.partner_id

Line 276: msc_system_items item

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
278: AND sd.publisher_order_type = SUPPLY_COMMIT
279: AND map1.tp_key = tp.partner_id
280: AND map1.map_type = 2 -- company