DBA Data[Home] [Help]

APPS.CSP_VALIDATE_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 113: from mtl_system_items_kfv

109: ELSE
110: BEGIN
111: -- validate whether the inventory_item_is exists in the given oranization_id
112: select inventory_item_id into l_check_existence
113: from mtl_system_items_kfv
114: where inventory_item_id = p_inventory_item_id
115: and organization_id = P_organization_id;
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN

Line 347: from mtl_system_items_kfv

343: IF p_inventory_item_id IS NULL THEN
344: RAISE EXCP_NO_REQ_PARAMETERS;
345: ELSE -- verify whether the item is assigned to the given organization_id
346: select count(organization_id) into l_count_qty
347: from mtl_system_items_kfv
348: where organization_id = p_organization_id
349: and inventory_item_id = p_inventory_item_id;
350:
351: IF l_count_qty = 0 THEN