View HLPDTEST.STATEGPS.T_PROJECT_NATIVE_TASK_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon May 23 01:05 IST 2022 |
View Definition:
SELECT T_GPS_APPLICATIONS.APPLICATION_NAME ,
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME ,
T_GPS_WORKFLOW_STATES.STATE_ID ,
T_GPS_WORKFLOW_STATES.STATE_NAME ,
T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR ,
T_PROJECT_TASK.PROJECT_TASK_ID ,
T_PROJECT_TASK.RESOURCE_NAME ,
T_PROJECT_TASK.ROLE_ID ,
T_PROJECT_TASK.USER_NAME ,
T_PROJECT_TASK.USER_ID ,
T_PROJECT_TASK.DURATION,
T_GPS_APPLICATIONS.APPLICATION_ID,
T_GPS_WORKFLOW_STATES.STATE_ORDER
FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS ,
STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES ,
STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES ,
STATEGPS.T_PROJECT_TASK T_PROJECT_TASK
WHERE T_PROJECT_TASK.STATE_ID = T_GPS_WORKFLOW_STATES.STATE_ID
AND T_GPS_WORKFLOW_TYPES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID
AND T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID
AND T_PROJECT_TASK.INSTANCE_ID IS NULL
AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true'
OR T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL )
AND T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR IN ( 'Default State','Notification State','Start State','Stop State','Escalation State')
UNION
SELECT T_GPS_APPLICATIONS.APPLICATION_NAME ,
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME ,
T_GPS_WORKFLOW_STATES.STATE_ID ,
T_GPS_WORKFLOW_STATES.STATE_NAME ,
T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL,
T_GPS_APPLICATIONS.APPLICATION_ID,
T_GPS_WORKFLOW_STATES.STATE_ORDER
FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS ,
STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES ,
STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES
WHERE T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_WORKFLOW_TYPES.APPLICATION_ID
AND T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID
AND T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR IN ( 'Default State','Notification State','Start State','Stop State','Escalation State')
AND NOT EXISTS
(SELECT T_PROJECT_TASK.STATE_ID
FROM STATEGPS.T_PROJECT_TASK T_PROJECT_TASK
WHERE T_GPS_WORKFLOW_STATES.STATE_ID = T_PROJECT_TASK.STATE_ID
AND T_PROJECT_TASK.INSTANCE_ID IS NULL
)
AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true'
OR T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL )
Possibly Referenced Tables/Views:
![]() ![]() |