View HLPDTEST.STATEGPS.MIG_REQUESTS_V Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
MIGRATION_REQUEST_ID number 22
PROJECT_NAME varchar2 255  √  null
MIGRATION_REQUEST_NUMBER varchar2 30  √  null
MIGRATION_REQUEST_TITLE varchar2 1000  √  null
INSTANCE_NAME varchar2 50  √  null
MIGRATION_STATUS varchar2 250  √  null
CREATED_BY varchar2 201  √  null
APPROVED_BY varchar2 201  √  null
APPROVAL_DATE date 7  √  null
LAST_UPDATED_BY varchar2 201  √  null
MIGRATION_WF_STATE varchar2 50  √  null
CREATED_DATE date 7  √  null
LAST_UPDATED_DATE date 7  √  null
UPLOAD_DOCUMENT_NAME varchar2 100  √  null
PREDECESSOR varchar2 500  √  null
WORKFLOW_TYPE varchar2 255
STATE_NAME varchar2 255  √  null
COMMENTS varchar2 4000  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
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
 
Possibly Referenced Tables/Views: