SELECT T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME , T_GPS_WORKFLOW_STATES.STATE_ID , T_GPS_WORKFLOW_STATES.STATE_NAME , T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR , T_PROJECT_TASK.PROJECT_TASK_ID , T_PROJECT_TASK.RESOURCE_NAME , T_PROJECT_TASK.ROLE_ID , T_PROJECT_TASK.USER_NAME , T_PROJECT_TASK.USER_ID , T_PROJECT_TASK.DURATION, T_GPS_APPLICATIONS.APPLICATION_ID, T_GPS_WORKFLOW_STATES.STATE_ORDER FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS , STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES , STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES , STATEGPS.T_PROJECT_TASK T_PROJECT_TASK WHERE T_PROJECT_TASK.STATE_ID = T_GPS_WORKFLOW_STATES.STATE_ID AND T_GPS_WORKFLOW_TYPES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID AND T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID AND T_PROJECT_TASK.INSTANCE_ID IS NULL AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' OR T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL ) AND T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR IN ( 'Default State','Notification State','Start State','Stop State','Escalation State') UNION SELECT T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME , T_GPS_WORKFLOW_STATES.STATE_ID , T_GPS_WORKFLOW_STATES.STATE_NAME , T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR , NULL , NULL , NULL , NULL , NULL , NULL, T_GPS_APPLICATIONS.APPLICATION_ID, T_GPS_WORKFLOW_STATES.STATE_ORDER FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS , STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES , STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES WHERE T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_WORKFLOW_TYPES.APPLICATION_ID AND T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID AND T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR IN ( 'Default State','Notification State','Start State','Stop State','Escalation State') AND NOT EXISTS (SELECT T_PROJECT_TASK.STATE_ID FROM STATEGPS.T_PROJECT_TASK T_PROJECT_TASK WHERE T_GPS_WORKFLOW_STATES.STATE_ID = T_PROJECT_TASK.STATE_ID AND T_PROJECT_TASK.INSTANCE_ID IS NULL ) AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' OR T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL )