SELECT T_MIGRATION_REQUESTS.MIGRATION_REQUEST_ID , T_MIGRATION_REQUESTS.PROJECT_NAME , T_MIGRATION_REQUESTS.MIGRATION_REQUEST_NUMBER , T_MIGRATION_REQUESTS.MIGRATION_REQUEST_TITLE , T_MIGRATION_REQUESTS.INSTANCE_NAME , T_MIGRATION_REQUESTS.MIGRATION_STATUS , (SELECT FIRST_NAME || ' ' || LAST_NAME FROM TAS.T_USERS WHERE USER_ID = T_MIGRATION_REQUESTS.CREATED_BY) CREATED_BY , (SELECT FIRST_NAME || ' ' || LAST_NAME FROM TAS.T_USERS WHERE USER_ID = T_MIGRATION_REQUESTS.APPROVED_BY)APPROVED_BY , T_MIGRATION_REQUESTS.APPROVAL_DATE , (SELECT FIRST_NAME || ' ' || LAST_NAME FROM TAS.T_USERS WHERE USER_ID = T_MIGRATION_REQUESTS.LAST_UPDATED_BY) LAST_UPDATED_BY , T_MIGRATION_REQUESTS.MIGRATION_WF_STATE , T_MIGRATION_REQUESTS.CREATED_DATE , T_MIGRATION_REQUESTS.LAST_UPDATED_DATE , T_MIGRATION_REQUESTS.UPLOAD_DOCUMENT_NAME , T_MIGRATION_REQUESTS.PREDECESSOR, T_GPS_WORKFLOW_TYPES.Workflow_Type_Name WORKFLOW_TYPE, T_GPS_WORKFLOW_STATES.STATE_NAME, T_GPS_INSTANCES.COMMENTS FROM TRI2GPS_DEV.T_MIGRATION_REQUESTS T_MIGRATION_REQUESTS , STATEGPS.T_GPS_INSTANCES T_GPS_INSTANCES , STATEGPS.T_GPS_INSTANCE_PROPERTIES T_GPS_INSTANCE_PROPERTIES, STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES , STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES, STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS WHERE T_MIGRATION_REQUESTS.MIGRATION_REQUEST_NUMBER = T_GPS_INSTANCE_PROPERTIES.PROPERTY_VALUE AND T_GPS_INSTANCE_PROPERTIES.PROPERTY_NAME = 'tri2.SG_TRI2_ENTITY.MIG_REQUEST_NUMBER' AND T_GPS_WORKFLOW_TYPES.Workflow_Type_Id=T_GPS_INSTANCES.WORKFLOW_TYPE_ID AND T_GPS_WORKFLOW_TYPES.Workflow_Type_Id=T_GPS_WORKFLOW_STATES.Workflow_Type_Id AND T_GPS_WORKFLOW_TYPES.VISIBLE_FLAG = 'true' AND T_GPS_INSTANCES.CURRENT_STATE_ID = T_GPS_WORKFLOW_STATES.STATE_ID AND T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_INSTANCES.APPLICATION_ID AND T_GPS_INSTANCES.INSTANCE_ID = T_GPS_INSTANCE_PROPERTIES.INSTANCE_ID AND T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_WORKFLOW_TYPES.APPLICATION_ID AND T_GPS_APPLICATIONS.APPLICATION_NAME = 'Application Object Migrator' AND T_GPS_INSTANCES.INSTANCE_PRESENT = 1 AND T_GPS_INSTANCES.ACTIVE = 1 ORDER BY T_MIGRATION_REQUESTS.LAST_UPDATED_DATE DESC