View HLPDTEST.STATEGPS.PROJECT_NATIVE_TASKS_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Apr 12 01:05 IST 2021 |
View Definition:
(
SELECT T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME ,
T_PROJECT_TASK.PROJECT_TASK_ID , T_PROJECT_TASK.TASK_NAME , T_PROJECT_TASK.RESOURCE_NAME ,
T_PROJECT_TASK.ROLE_ID , T_PROJECT_TASK.USER_NAME , T_PROJECT_TASK.USER_ID , T_PROJECT_TASK.START_DATE ,
T_PROJECT_TASK.FINISH_DATE , T_PROJECT_TASK.DURATION , T_PROJECT_TASK.STATE_ID STATE_ID,
TO_CHAR(T_GPS_WORKFLOW_STATES.STATE_ID) STATE_ID_STR
FROM
STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS,
STATEGPS.T_GPS_APP_PROPERTIES T_GPS_APP_PROPERTIES,
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_PROJECT_TASK.TASK_NAME = T_GPS_WORKFLOW_STATES.STATE_NAME
AND T_GPS_WORKFLOW_TYPES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID
AND T_GPS_APP_PROPERTIES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID
AND T_GPS_APP_PROPERTIES.PROPERTY_NAME = 'PROJECTPLAN_APPLICATION'
AND T_GPS_APP_PROPERTIES.PROPERTY_VALUE = 'TRUE'
AND T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID
AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL OR T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' )
UNION
SELECT
T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME , NULL ,
T_GPS_WORKFLOW_STATES.STATE_NAME , NULL , NULL , NULL , NULL , NULL , NULL , NULL ,
T_GPS_WORKFLOW_STATES.STATE_ID , TO_CHAR(T_GPS_WORKFLOW_STATES.STATE_ID) STATE_ID_STR
FROM
STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS,
STATEGPS.T_GPS_APP_PROPERTIES T_GPS_APP_PROPERTIES,
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
NOT IN ( 'Workflow','Workflow Start','Workflow End','AND 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_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_APP_PROPERTIES.APPLICATION_ID
AND T_GPS_APP_PROPERTIES.PROPERTY_NAME = 'PROJECTPLAN_APPLICATION' AND
T_GPS_APP_PROPERTIES.PROPERTY_VALUE = 'TRUE'
AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' OR T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL )
)
Possibly Referenced Tables/Views:
![]() ![]() |