View HLPDTEST.STATEGPS.T_TASK_PREDECESSOR_EXISTS_V | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||
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:
![]() ![]() |