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