( SELECT UNIQUE PROJECTTASKS.TASK_NAME, PROJECTTASKS.TASK_ID, PROJECTTASKS.PRIORITY, APPLICATIONS.APPLICATION_NAME FROM T_GPS_APPLICATIONS APPLICATIONS, T_GPS_WORKFLOW_TYPES WORKFLOWS, T_GPS_WORKFLOW_STATES STATES, T_PROJECT_TASK PROJECTTASKS WHERE PROJECTTASKS.STATE_ID = STATES.STATE_ID AND STATES.WORKFLOW_TYPE_ID = WORKFLOWS.WORKFLOW_TYPE_ID AND WORKFLOWS.APPLICATION_ID = APPLICATIONS.APPLICATION_ID AND PROJECTTASKS.TASK_NAME IS NOT NULL AND PROJECTTASKS.INSTANCE_ID IS NOT NULL and (APPLICATIONS.VISIBLE_FLAG IS NULL OR APPLICATIONS.VISIBLE_FLAG = 'true') )