APPS.CST_INVENTORY_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 132: mtl_system_items_kfv MSI,

128: SELECT MSI.inventory_item_id,
129: MIC.category_id,
130: CIC.cost_type_id
131: FROM mtl_item_categories MIC,
132: mtl_system_items_kfv MSI,
133: cst_item_costs CIC
134: -- cst_item_costs CIC1,
135: -- cst_item_costs CIC2
136: WHERE MIC.category_set_id = p_category_set_id

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 224: mtl_system_items_kfv MSI,

220: MIC.category_id,
221: CIC.cost_type_id
222: FROM mtl_item_categories MIC,
223: mtl_categories_kfv MC,
224: mtl_system_items_kfv MSI,
225: cst_item_costs CIC
226: -- cst_item_costs CIC1,
227: -- cst_item_costs CIC2
228: WHERE MC.concatenated_segments

Line 275: mtl_system_items_kfv MSI,

271: MIC.category_id,
272: CIC.cost_type_id
273: FROM mtl_item_categories MIC,
274: mtl_categories_kfv MC,
275: mtl_system_items_kfv MSI,
276: cst_item_costs CIC,
277: cst_item_costs CIC1,
278: cst_item_costs CIC2
279: WHERE MC.concatenated_segments

Line 338: mtl_system_items_kfv MSI

334: MIC.category_id,
335: l_def_cost_type_id
336: FROM mtl_item_categories MIC,
337: mtl_categories_kfv MC,
338: mtl_system_items_kfv MSI
339: WHERE MC.concatenated_segments
340: BETWEEN NVL(p_category_from,MC.concatenated_segments)
341: AND NVL(p_category_to,MC.concatenated_segments)
342: AND MC.structure_id = (SELECT structure_id FROM mtl_category_sets WHERE category_set_id = p_category_set_id)