View HLPDTEST.STATEGPS.T_INSTANCE_OWNER_V | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Wed May 25 01:05 IST 2022 |
View Definition:
SELECT A.OWNER,A.INSTANCE_ID,A.CURRENT_STATE_ID,A.CREATED_DATE
FROM T_GPS_INSTANCES A WHERE A.CREATED_DATE = (SELECT MIN(Y.CREATED_DATE) FROM T_GPS_INSTANCES Y WHERE A.INSTANCE_ID = Y.INSTANCE_ID
AND Y.CURRENT_STATE_ID = (SELECT MIN(X.CURRENT_STATE_ID) FROM T_GPS_INSTANCES X WHERE A.INSTANCE_ID = X.INSTANCE_ID))
Possibly Referenced Tables/Views:
![]() ![]() |