213: X_ITEM_CODE := NULL;
214: BEGIN
215: IF C_INVENTORY_ID IS NOT NULL THEN
216: SELECT
217: MTL_SYSTEM_ITEMS.SEGMENT1
218: INTO X_ITEM_CODE
219: FROM
220: MTL_SYSTEM_ITEMS
221: WHERE MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID = C_INVENTORY_ID
216: SELECT
217: MTL_SYSTEM_ITEMS.SEGMENT1
218: INTO X_ITEM_CODE
219: FROM
220: MTL_SYSTEM_ITEMS
221: WHERE MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID = C_INVENTORY_ID
222: AND MTL_SYSTEM_ITEMS.ORGANIZATION_ID = H_SO_ORGANIZATION;
223: END IF;
224: EXCEPTION
217: MTL_SYSTEM_ITEMS.SEGMENT1
218: INTO X_ITEM_CODE
219: FROM
220: MTL_SYSTEM_ITEMS
221: WHERE MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID = C_INVENTORY_ID
222: AND MTL_SYSTEM_ITEMS.ORGANIZATION_ID = H_SO_ORGANIZATION;
223: END IF;
224: EXCEPTION
225: WHEN OTHERS THEN
218: INTO X_ITEM_CODE
219: FROM
220: MTL_SYSTEM_ITEMS
221: WHERE MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID = C_INVENTORY_ID
222: AND MTL_SYSTEM_ITEMS.ORGANIZATION_ID = H_SO_ORGANIZATION;
223: END IF;
224: EXCEPTION
225: WHEN OTHERS THEN
226: NULL;