344: ,MTL_CATEGORY_SETS_VL mcs
345: ,( SELECT mic.ORGANIZATION_ID
346: ,mic.CATEGORY_SET_ID
347: ,mic.CATEGORY_ID
348: FROM MTL_ITEM_CATEGORIES mic
349: WHERE mic.ORGANIZATION_ID = p_org_id
350: GROUP BY mic.ORGANIZATION_ID
351: ,mic.CATEGORY_SET_ID
352: ,mic.CATEGORY_ID ) x
1473:
1474: select 'Y' INTO l_category_exist FROM dual
1475: where exists
1476: (select mic.category_id
1477: from mtl_item_categories mic
1478: where mic.organization_id = p_org_id
1479: and mic.inventory_item_id = p_inventory_item_id
1480: and mic.category_set_id = p_category_set_id
1481: and mic.category_id = p_category_id);