View HLPDTEST.STATEGPS.WEEKLY_OPEN_CLOSE_MIGRATIONS_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
PROJECT varchar2 255  √  null
TICKET_DATE date 8  √  null
STATUS varchar2 6  √  null
COUNT number 22  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
SELECT T_GPS_APPLICATIONS.APPLICATION_NAME PROJECT, next_day(trunc(T_MIGRATION_REQUESTS.CREATED_DATE)-7,'Monday') TICKET_DATE , DECODE(T_MIGRATION_REQUESTS.MIGRATION_WF_STATE,'MIGRATED TO PRODUCTION','CLOSED','OPEN') STATUS , count(distinct T_GPS_INSTANCE_PROPERTIES.instance_id) COUNT FROM STATEGPS.T_GPS_INSTANCES T_GPS_INSTANCES , TRI2GPS_DEV.T_MIGRATION_REQUESTS T_MIGRATION_REQUESTS , STATEGPS.T_GPS_INSTANCE_PROPERTIES T_GPS_INSTANCE_PROPERTIES , STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS , STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES WHERE T_MIGRATION_REQUESTS.MIGRATION_REQUEST_NUMBER = T_GPS_INSTANCE_PROPERTIES.PROPERTY_VALUE AND T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_INSTANCES.APPLICATION_ID AND T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID = T_GPS_INSTANCES.WORKFLOW_TYPE_ID AND T_GPS_INSTANCE_PROPERTIES.INSTANCE_ID = T_GPS_INSTANCES.INSTANCE_ID AND T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' AND T_GPS_APPLICATIONS.APPLICATION_NAME LIKE 'Application Object Migrator' AND T_GPS_INSTANCES.ACTIVE = '1' GROUP BY T_GPS_INSTANCE_PROPERTIES.INSTANCE_ID,T_GPS_APPLICATIONS.APPLICATION_NAME,T_MIGRATION_REQUESTS.MIGRATION_WF_STATE,T_MIGRATION_REQUESTS.CREATED_DATE
 
Possibly Referenced Tables/Views: