APPS.ENG_CHANGE_ATTR_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 252: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

248: DECLARE
249:
250: l_error_message_name VARCHAR2(30);
251: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
252: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
253:
254: BEGIN
255:
256: IF (l_return_status = 'F') THEN

Line 264: FROM MTL_SYSTEM_ITEMS_KFV

260: END IF;
261:
262: SELECT CONCATENATED_SEGMENTS
263: INTO l_item_number
264: FROM MTL_SYSTEM_ITEMS_KFV
265: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
266: AND ORGANIZATION_ID = p_organization_id;
267:
268: SELECT ORGANIZATION_CODE