SELECT APPLICATIONS.Application_Name APPLICATION, APPLICATIONS.APPLICATION_ID APPLICATION_ID, WTYPES.WORKFLOW_TYPE_NAME WORK_FLOW, WTYPES.WORKFLOW_TYPE_ID WORKFLOW_TYPE_ID, WS.STATE_NAME STATE, GN.NODETYPE NODE_TYPE, NS.UPDATED_AT UPDATED_DATE, GN.DESCRIPTION DESCRIPTION, NS.NODETYPE_STATE_ID NODETYPE_STATE_ID, GN.NODETYPE_ID NODETYPE_ID FROM T_GPS_APPLICATIONS APPLICATIONS, T_GPS_WORKFLOW_TYPES WTYPES, t_gps_workflow_states WS, T_GPS_NODETYPE_STATES NS, T_GPS_NODETYPES GN WHERE APPLICATIONS.VISIBLE_FLAG = 'true' AND APPLICATIONS.APPLICATION_ID = WTYPES.APPLICATION_ID AND WTYPES.VISIBLE_FLAG = 'true' AND WTYPES.WORKFLOW_TYPE_ID = WS.WORKFLOW_TYPE_ID AND WS.STATE_ID = NS.STATE_ID AND WS.VISIBLE_FLAG = 'true' AND NS.NODETYPE_ID = GN.NODETYPE_ID AND WTYPES.VISIBLE_FLAG = 'true' UNION SELECT APPLICATIONS.Application_Name APPLICATION, APPLICATIONS.APPLICATION_ID APPLICATION_ID, NULL WORK_FLOW, NULL WORKFLOW_TYPE_ID, NULL STATE, GN.NODETYPE NODE_TYPE, NS.UPDATED_AT UPDATED_DATE, GN.DESCRIPTION DESCRIPTION, NS.NODETYPE_STATE_ID NODETYPE_STATE_ID, GN.NODETYPE_ID NODETYPE_ID FROM T_GPS_NODETYPE_STATES NS, T_GPS_NODETYPES GN, T_GPS_APPLICATIONS APPLICATIONS WHERE NS.NODETYPE_ID = GN.NODETYPE_ID AND NS.VISIBLE_FLAG = 'true' AND APPLICATIONS.APPLICATION_ID = NS.APPLICATION_ID AND APPLICATIONS.VISIBLE_FLAG = 'true'