View HLPDTEST.STATEGPS.T_TASK_PREDECESSOR_EXISTS_V Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
INSTANCE_PRESENT number 22  √  null
PROJECT_TASK_ID number 22
T_PROJECT_TASK.PROJECT_TASK_ID Implied Constraint R

Analyzed at Sun Jan 17 01:06 IST 2021

View Definition:
SELECT gi.instance_present, pt.project_task_id from t_gps_instances gi, t_project_task pt, t_gps_workflow_states ws, t_instance_predecessor ip, t_gps_workflow_states ws1 where gi.instance_id = pt.instance_id and gi.current_state_id = pt.state_id AND IP.INSTANCE_ID = PT.INSTANCE_ID and pt.state_id = ws.state_id --and gi.instance_id = ip.PRED_INSTANCE_ID and nvl(ip.pred_state_id, ws.state_id) = ws1.state_id and ws.state_order <= ws1.state_order -- If the ip.pred_state_id is null, then use gi.current_state_id -- and gi.current_state_id <= nvl(ip.pred_state_id,gi.current_state_id)) -- The predecessor instance should be active=1 and instance_present=1 and gi.instance_present = 1 and gi.active = 1
 
Possibly Referenced Tables/Views:


Close relationships: