APPS.CST_INVENTORY_PVT dependencies on MTL_CATEGORY_SETS

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

227: -- cst_item_costs CIC2
228: WHERE MC.concatenated_segments
229: BETWEEN NVL(p_category_from,MC.concatenated_segments)
230: AND NVL(p_category_to,MC.concatenated_segments)
231: AND MC.structure_id = (SELECT structure_id FROM mtl_category_sets WHERE category_set_id = p_category_set_id)
232: AND MIC.category_id = MC.category_id
233: AND MIC.category_set_id = p_category_set_id
234: AND MIC.organization_id = p_organization_id
235: AND MSI.organization_id = p_organization_id

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

278: cst_item_costs CIC2
279: WHERE MC.concatenated_segments
280: BETWEEN NVL(p_category_from,MC.concatenated_segments)
281: AND NVL(p_category_to,MC.concatenated_segments)
282: AND MC.structure_id = (SELECT structure_id FROM mtl_category_sets WHERE category_set_id = p_category_set_id)
283: AND MIC.category_id = MC.category_id
284: AND MIC.category_set_id = p_category_set_id
285: AND MIC.organization_id = p_organization_id
286: AND MSI.organization_id = p_organization_id

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

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)
343: AND MIC.category_id = MC.category_id
344: AND MIC.category_set_id = p_category_set_id
345: AND MIC.organization_id = p_organization_id
346: AND MSI.organization_id = p_organization_id