DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on MTL_CATEGORIES_KFV

Line 223: mtl_categories_kfv MC,

219: SELECT MSI.inventory_item_id,
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

Line 274: mtl_categories_kfv MC,

270: SELECT MSI.inventory_item_id,
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

Line 337: mtl_categories_kfv MC,

333: SELECT MSI.inventory_item_id,
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)