View HLPDTEST.STATEGPS.T_PROJECT_DA_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||
Analyzed at Sun Jan 24 01:06 IST 2021 |
View Definition:
(SELECT A.STATE_ID, A.TASK_ID, A.TASK_NAME || ' @ ' || B.STATE_NAME AS TASK_NAME FROM T_PROJECT_TASK A, T_GPS_WORKFLOW_STATES B
WHERE A.TASK_NAME != B.STATE_NAME AND A.STATE_ID = B.STATE_ID) UNION
(SELECT A.STATE_ID, A.TASK_ID, A.TASK_NAME FROM T_PROJECT_TASK A, T_GPS_WORKFLOW_STATES B
WHERE A.TASK_NAME = B.STATE_NAME AND A.STATE_ID = B.STATE_ID)
Possibly Referenced Tables/Views:
![]() ![]() |