1771: IF p_inventory_item_id IS NOT NULL
1772: THEN
1773: SELECT DISTINCT(inventory_item_id)
1774: INTO x_inventory_item_id
1775: FROM MTL_SYSTEM_ITEMS_B_KFV
1776: WHERE inventory_item_id = p_inventory_item_id;
1777: END IF;
1778: --
1779: IF p_item_description IS NOT NULL THEN
1778: --
1779: IF p_item_description IS NOT NULL THEN
1780: SELECT DISTINCT(inventory_item_id)
1781: INTO x_inventory_item_id
1782: FROM MTL_SYSTEM_ITEMS_B_KFV
1783: WHERE concatenated_segments = p_item_description;
1784: END IF;
1785: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1786: IF G_DEBUG='Y' THEN