View HLPDTEST.STATEGPS.VR_SCHEDULE_V | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue May 24 01:05 IST 2022 |
View Definition:
SELECT T_GPS_APPLICATIONS.APPLICATION_NAME,
T_GPS_VIEWER_INSTANCES_SET.SET_NAME,
T_GPS_VIEWER_INSTANCES.FORM_NAME,
T_GPS_VIEWER_SCHEDULE.SCHEDULE_ID,
T_GPS_VIEWER_SCHEDULE.START_DATE,
T_GPS_VIEWER_SCHEDULE.START_TIME,
T_GPS_VIEWER_SCHEDULE.END_DATE,
T_GPS_VIEWER_SCHEDULE.SCHEDULE_TYPE,
T_GPS_VIEWER_SCHEDULE.JOB_ID,
T_GPS_VIEWER_SCHEDULE.JOB_TYPE_ID,
T_GPS_VIEWER_SCHEDULE.VIEWER_SCHEDULE_ID,
T_GPS_VIEWER_SCHEDULE.ATTACHMENT_FLAG,
T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID,
T_GPS_VIEWER_INSTANCES.VISIBLE_FLAG
FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS,
T_GPS_VIEWER_INSTANCES_SET T_GPS_VIEWER_INSTANCES_SET,
T_GPS_VIEWER_INSTANCES T_GPS_VIEWER_INSTANCES,
T_GPS_VIEWER_SCHEDULE T_GPS_VIEWER_SCHEDULE
WHERE T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_VIEWER_INSTANCES_SET.APPLICATION_ID
AND T_GPS_VIEWER_INSTANCES_SET.SET_ID = T_GPS_VIEWER_INSTANCES.SET_ID
AND T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID = T_GPS_VIEWER_SCHEDULE.VIEWER_INSTANCES_ID(+)
Possibly Referenced Tables/Views:
![]() ![]() |