webco_8.0
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
find_res_next_sched_oid
Parameters
Name
Type
Mode
$1
bigint
IN
Definition
begin return (select obj_oid from resource_schedule t1 where scheduled_resource_oid = $1 and type = 'RESERVATION' and exists ( select null from ( select scheduled_resource_oid, min(start_time) st from resource_schedule where type = 'RESERVATION' group by scheduled_resource_oid ) t2 where t2.scheduled_resource_oid = t1.scheduled_resource_oid and t2.st = t1.start_time) limit 1 ); end