[Home] [Help]
229: IF l_org_id IS NOT NULL THEN
230:
231: SELECT CATEGORY_ID
232: INTO l_item_category_id
233: FROM MTL_ITEM_CATEGORIES CAT
234: , MTL_DEFAULT_CATEGORY_SETS DCS
235: WHERE CAT.INVENTORY_ITEM_ID = p_item_id
236: AND CAT.ORGANIZATION_ID = l_org_id
237: AND CAT.CATEGORY_SET_ID = DCS.CATEGORY_SET_ID