( SELECT T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME , T_PROJECT_TASK.PROJECT_TASK_ID , T_PROJECT_TASK.TASK_NAME , T_PROJECT_TASK.RESOURCE_NAME , T_PROJECT_TASK.ROLE_ID , T_PROJECT_TASK.USER_NAME , T_PROJECT_TASK.USER_ID , T_PROJECT_TASK.START_DATE , T_PROJECT_TASK.FINISH_DATE , T_PROJECT_TASK.DURATION , T_PROJECT_TASK.STATE_ID STATE_ID, TO_CHAR(T_GPS_WORKFLOW_STATES.STATE_ID) STATE_ID_STR FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS, STATEGPS.T_GPS_APP_PROPERTIES T_GPS_APP_PROPERTIES, 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_PROJECT_TASK.TASK_NAME = T_GPS_WORKFLOW_STATES.STATE_NAME AND T_GPS_WORKFLOW_TYPES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID AND T_GPS_APP_PROPERTIES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID AND T_GPS_APP_PROPERTIES.PROPERTY_NAME = 'PROJECTPLAN_APPLICATION' AND T_GPS_APP_PROPERTIES.PROPERTY_VALUE = 'TRUE' AND T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL OR T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' ) UNION SELECT T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME , NULL , T_GPS_WORKFLOW_STATES.STATE_NAME , NULL , NULL , NULL , NULL , NULL , NULL , NULL , T_GPS_WORKFLOW_STATES.STATE_ID , TO_CHAR(T_GPS_WORKFLOW_STATES.STATE_ID) STATE_ID_STR FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS, STATEGPS.T_GPS_APP_PROPERTIES T_GPS_APP_PROPERTIES, 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 NOT IN ( 'Workflow','Workflow Start','Workflow End','AND 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_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_APP_PROPERTIES.APPLICATION_ID AND T_GPS_APP_PROPERTIES.PROPERTY_NAME = 'PROJECTPLAN_APPLICATION' AND T_GPS_APP_PROPERTIES.PROPERTY_VALUE = 'TRUE' AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' OR T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL ) )