104: GROUP BY INVENTORY_ITEM_ID;
105:
106: SELECT DESCRIPTION
107: INTO x_config_item_description 108: FROM MTL_SYSTEM_ITEMS M 109: WHERE M.INVENTORY_ITEM_ID = x_configuration_item_id
110: AND M.ORGANIZATION_ID = NVL(x_warehouse_id, x_organization_id);
111:
112: EXCEPTION