DBA Data[Home] [Help]

APPS.EAM_ACTIVITYUTILITIES_PVT dependencies on CSI_ITEM_INSTANCES

Line 713: FROM csi_item_instances

709: IF p_instance_number IS NOT NULL THEN
710: BEGIN
711: SELECT instance_id, 3
712: INTO x_maintenance_object_id, x_maintenance_object_type
713: FROM csi_item_instances
714: WHERE instance_number = p_instance_number;
715: EXCEPTION
716: WHEN OTHERS THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;

Line 762: FROM csi_item_instances

758: -- 2) Validate Asset Group and Serial Number
759: BEGIN
760: SELECT instance_id, 3
761: INTO x_maintenance_object_id, x_maintenance_object_type
762: FROM csi_item_instances
763: WHERE inventory_item_id = p_inventory_item_id
764: AND serial_number = p_serial_number;
765: EXCEPTION
766: WHEN OTHERS THEN