DBA Data[Home] [Help]

APPS.CSP_PC_FORM_PICKLINES dependencies on MTL_SYSTEM_ITEMS_KFV

Line 221: from mtl_system_items_kfv

217: ELSE
218: BEGIN
219: -- validate whether the inventory_item_is exists in the given oranization_id
220: select inventory_item_id into l_check_existence
221: from mtl_system_items_kfv
222: where inventory_item_id = p_inventory_item_id
223: and organization_id = l_organization_id;
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN

Line 397: from mtl_system_items_kfv

393: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
394: BEGIN
395: -- validate whether the inventory_item_is exists in the given oranization_id
396: select inventory_item_id into l_check_existence
397: from mtl_system_items_kfv
398: where inventory_item_id = p_inventory_item_id
399: and organization_id = l_organization_id;
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN