APPS.CST_INVENTORY_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 174: mtl_system_items_kfv MSI,

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
178: WHERE MIC.category_set_id = p_category_set_id

Line 215: mtl_system_items_kfv MSI,

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
219: WHERE MIC.category_set_id = p_category_set_id

Line 262: mtl_system_items_kfv MSI,

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,
265: -- cst_item_costs CIC2
266: WHERE MC.concatenated_segments

Line 313: mtl_system_items_kfv MSI,

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,
316: cst_item_costs CIC2
317: WHERE MC.concatenated_segments

Line 376: mtl_system_items_kfv MSI

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)
379: AND NVL(p_category_to,MC.concatenated_segments)
380: AND MC.structure_id = (SELECT structure_id FROM mtl_category_sets WHERE category_set_id = p_category_set_id)