APPS.CST_INVENTORY_PVT dependencies on MTL_CATEGORY_SETS

Line 269: AND MC.structure_id = (SELECT structure_id FROM mtl_category_sets WHERE category_set_id = p_category_set_id)

265: -- cst_item_costs CIC2
266: WHERE MC.concatenated_segments
267: BETWEEN NVL(p_category_from,MC.concatenated_segments)
268: AND NVL(p_category_to,MC.concatenated_segments)
269: AND MC.structure_id = (SELECT structure_id FROM mtl_category_sets WHERE category_set_id = p_category_set_id)
270: AND MIC.category_id = MC.category_id
271: AND MIC.category_set_id = p_category_set_id
272: AND MIC.organization_id = p_organization_id
273: AND MSI.organization_id = p_organization_id

Line 320: AND MC.structure_id = (SELECT structure_id FROM mtl_category_sets WHERE category_set_id = p_category_set_id)

316: cst_item_costs CIC2
317: WHERE MC.concatenated_segments
318: BETWEEN NVL(p_category_from,MC.concatenated_segments)
319: AND NVL(p_category_to,MC.concatenated_segments)
320: AND MC.structure_id = (SELECT structure_id FROM mtl_category_sets WHERE category_set_id = p_category_set_id)
321: AND MIC.category_id = MC.category_id
322: AND MIC.category_set_id = p_category_set_id
323: AND MIC.organization_id = p_organization_id
324: AND MSI.organization_id = p_organization_id

Line 380: AND MC.structure_id = (SELECT structure_id FROM mtl_category_sets WHERE category_set_id = p_category_set_id)

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)
381: AND MIC.category_id = MC.category_id
382: AND MIC.category_set_id = p_category_set_id
383: AND MIC.organization_id = p_organization_id
384: AND MSI.organization_id = p_organization_id