View HLPDTEST.STATEGPS.T_GPS_APPLICATION_NODE_TYPES | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Wed May 25 01:05 IST 2022 |
View Definition:
SELECT APPLICATIONS.Application_Name APPLICATION,
APPLICATIONS.APPLICATION_ID APPLICATION_ID,
WTYPES.WORKFLOW_TYPE_NAME WORK_FLOW,
WTYPES.WORKFLOW_TYPE_ID WORKFLOW_TYPE_ID,
WS.STATE_NAME STATE,
GN.NODETYPE NODE_TYPE,
NS.UPDATED_AT UPDATED_DATE,
GN.DESCRIPTION DESCRIPTION,
NS.NODETYPE_STATE_ID NODETYPE_STATE_ID,
GN.NODETYPE_ID NODETYPE_ID
FROM T_GPS_APPLICATIONS APPLICATIONS,
T_GPS_WORKFLOW_TYPES WTYPES,
t_gps_workflow_states WS,
T_GPS_NODETYPE_STATES NS,
T_GPS_NODETYPES GN
WHERE APPLICATIONS.VISIBLE_FLAG = 'true'
AND APPLICATIONS.APPLICATION_ID = WTYPES.APPLICATION_ID
AND WTYPES.VISIBLE_FLAG = 'true'
AND WTYPES.WORKFLOW_TYPE_ID = WS.WORKFLOW_TYPE_ID
AND WS.STATE_ID = NS.STATE_ID
AND WS.VISIBLE_FLAG = 'true'
AND NS.NODETYPE_ID = GN.NODETYPE_ID
AND WTYPES.VISIBLE_FLAG = 'true'
UNION
SELECT APPLICATIONS.Application_Name APPLICATION,
APPLICATIONS.APPLICATION_ID APPLICATION_ID,
NULL WORK_FLOW,
NULL WORKFLOW_TYPE_ID,
NULL STATE,
GN.NODETYPE NODE_TYPE,
NS.UPDATED_AT UPDATED_DATE,
GN.DESCRIPTION DESCRIPTION,
NS.NODETYPE_STATE_ID NODETYPE_STATE_ID,
GN.NODETYPE_ID NODETYPE_ID
FROM T_GPS_NODETYPE_STATES NS,
T_GPS_NODETYPES GN,
T_GPS_APPLICATIONS APPLICATIONS
WHERE NS.NODETYPE_ID = GN.NODETYPE_ID
AND NS.VISIBLE_FLAG = 'true'
AND APPLICATIONS.APPLICATION_ID = NS.APPLICATION_ID
AND APPLICATIONS.VISIBLE_FLAG = 'true'
Possibly Referenced Tables/Views:
![]() ![]() |