DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on MTL_CATEGORIES_KFV

Line 261: mtl_categories_kfv MC,

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,
265: -- cst_item_costs CIC2

Line 312: mtl_categories_kfv MC,

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,
316: cst_item_costs CIC2

Line 375: mtl_categories_kfv MC,

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)
379: AND NVL(p_category_to,MC.concatenated_segments)