View HLPDTEST.STATEGPS.T_GPS_APP_WORKFLOW_STATES_VIEW | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Mar 01 01:05 IST 2021 |
View Definition:
(
SELECT T1.APPLICATION_ID,T1.APPLICATION_NAME,T2.WORKFLOW_TYPE_ID,T2.WORKFLOW_TYPE_NAME,
T2.DESCRIPTION "WORKFLOW_DESCRIPTION",T3.STATE_ID,T3.STATE_NAME,T3.DESCRIPTION "STATES_DESCRIPTION"
FROM T_GPS_APPLICATIONS T1,T_GPS_WORKFLOW_TYPES T2,T_GPS_WORKFLOW_STATES T3
WHERE T1.APPLICATION_ID = T2.APPLICATION_ID AND T2.WORKFLOW_TYPE_ID = T3.WORKFLOW_TYPE_ID
)
Possibly Referenced Tables/Views:
![]() ![]() |