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.CST_INVENTORY_PVT dependencies on MTL_ITEM_CATEGORIES

Line 173: FROM mtl_item_categories MIC,

169: )
170: SELECT MSI.inventory_item_id,
171: MIC.category_id,
172: CIC.cost_type_id
173: FROM mtl_item_categories MIC,
174: mtl_system_items_kfv MSI,
175: cst_item_costs CIC
176: -- cst_item_costs CIC1,
177: -- cst_item_costs CIC2

Line 214: FROM mtl_item_categories MIC,

210: )
211: SELECT MSI.inventory_item_id,
212: MIC.category_id,
213: CIC.cost_type_id
214: FROM mtl_item_categories MIC,
215: mtl_system_items_kfv MSI,
216: cst_item_costs CIC,
217: cst_item_costs CIC1,
218: cst_item_costs CIC2

Line 260: FROM mtl_item_categories MIC,

256: )
257: SELECT MSI.inventory_item_id,
258: MIC.category_id,
259: CIC.cost_type_id
260: FROM mtl_item_categories MIC,
261: mtl_categories_kfv MC,
262: mtl_system_items_kfv MSI,
263: cst_item_costs CIC
264: -- cst_item_costs CIC1,

Line 311: FROM mtl_item_categories MIC,

307: )
308: SELECT MSI.inventory_item_id,
309: MIC.category_id,
310: CIC.cost_type_id
311: FROM mtl_item_categories MIC,
312: mtl_categories_kfv MC,
313: mtl_system_items_kfv MSI,
314: cst_item_costs CIC,
315: cst_item_costs CIC1,

Line 374: FROM mtl_item_categories MIC,

370: )
371: SELECT MSI.inventory_item_id,
372: MIC.category_id,
373: l_def_cost_type_id
374: FROM mtl_item_categories MIC,
375: mtl_categories_kfv MC,
376: mtl_system_items_kfv MSI
377: WHERE MC.concatenated_segments
378: BETWEEN NVL(p_category_from,MC.concatenated_segments)