View HLPDTEST.STATEGPS.T_GPS_APPLICATIONS_MATRIX_V Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
APPLICATION varchar2 255  √  null
APPLICATION_GROUP varchar2 255  √  null
WORK_FLOW varchar2 255  √  null
STATES varchar2 255  √  null
NODE_TYPES varchar2 255  √  null
WOKFLOW_OPERATIONS varchar2 255  √  null
VIEWER_SET varchar2 255  √  null
VIEWER_INSTANCE varchar2 255  √  null
CUSTOM_SET varchar2 255  √  null
APPLICATION_VISIBLE_FLAG varchar2 255  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
SELECT APPLICATIONS.Application_Name Application, CATEGORIES.CATEGORY_NAME APPLICATION_GROUP, WTYPES.WORKFLOW_TYPE_NAME WORK_FLOW, WS.STATE_NAME STATES, NULL NODE_TYPES, SOP.OPERATION_NAME WOKFLOW_OPERATIONS, NULL VIEWER_SET, NULL VIEWER_INSTANCE, NULL CUSTOM_SET, APPLICATIONS.VISIBLE_FLAG APPLICATION_VISIBLE_FLAG FROM T_GPS_APPLICATIONS APPLICATIONS, T_GPS_WORKFLOW_TYPES WTYPES, T_GPS_WORKFLOW_STATES WS, T_GPS_STATE_OPERATIONS SOP, T_APP_GROUPS APPGROUPS, T_CATEGORIES CATEGORIES WHERE APPLICATIONS.APPLICATION_ID = WTYPES.APPLICATION_ID AND WTYPES.WORKFLOW_TYPE_ID = WS.WORKFLOW_TYPE_ID AND SOP.WORKFLOW_TYPE_ID = WS.WORKFLOW_TYPE_ID AND WS.STATE_ID = SOP.FROM_STATE_ID AND APPLICATIONS.APPLICATION_ID = APPGROUPS.APP_ID AND APPGROUPS.CATEGORY_ID = CATEGORIES.CATEGORY_ID AND WTYPES.VISIBLE_FLAG = 'true' AND WS.VISIBLE_FLAG = 'true' /* parallel */ UNION SELECT APPLICATIONS.Application_Name Application, CATEGORIES.CATEGORY_NAME APPLICATION_GROUP, NULL WORK_FLOW, NULL STATES, NULL NODE_TYPES, NULL WOKFLOW_OPERATIONS, VSET.DISPLAY_NAME VIEWER_SET, VI.FORM_NAME VIEWER_INSTANCE, NULL CUSTOM_SET, APPLICATIONS.VISIBLE_FLAG APPLICATION_VISIBLE_FLAG FROM T_GPS_APPLICATIONS APPLICATIONS, T_GPS_VIEWER_INSTANCES_SET VSET, T_GPS_VIEWER_INSTANCES VI, T_APP_GROUPS APPGROUPS, T_CATEGORIES CATEGORIES WHERE APPLICATIONS.APPLICATION_ID = VSET.APPLICATION_ID AND VSET.SET_ID = VI.SET_ID AND APPLICATIONS.APPLICATION_ID = APPGROUPS.APP_ID AND APPGROUPS.CATEGORY_ID = CATEGORIES.CATEGORY_ID AND VSET.VISIBLE_FLAG = 'true' AND VI.VISIBLE_FLAG = 'true' /* parallel */ UNION SELECT APPLICATIONS.Application_Name Application, CATEGORIES.CATEGORY_NAME APPLICATION_GROUP, NULL WORK_FLOW, NULL STATES, NULL NODE_TYPES, NULL WOKFLOW_OPERATIONS, NULL VIEWER_SET, NULL VIEWER_INSTANCE, CSET.Custom_Set_Name CUSTOM_SET, APPLICATIONS.VISIBLE_FLAG APPLICATION_VISIBLE_FLAG FROM T_GPS_APPLICATIONS APPLICATIONS , T_GPS_CUSTOM_SETS CSET, T_APP_GROUPS APPGROUPS, T_CATEGORIES CATEGORIES WHERE APPLICATIONS.APPLICATION_ID = CSET.APPLICATION_ID AND APPLICATIONS.APPLICATION_ID = APPGROUPS.APP_ID AND APPGROUPS.CATEGORY_ID = CATEGORIES.CATEGORY_ID AND CSET.VISIBLE_FLAG = 'true' /* parallel */ UNION SELECT APPLICATIONS.Application_Name Application, CATEGORIES.CATEGORY_NAME APPLICATION_GROUP, NULL WORK_FLOW, NULL STATES, GN.NODETYPE NODE_TYPES, NULL WOKFLOW_OPERATIONS, NULL VIEWER_SET, NULL VIEWER_INSTANCE, NULL CUSTOM_SET, APPLICATIONS.VISIBLE_FLAG APPLICATION_VISIBLE_FLAG FROM T_GPS_APPLICATIONS APPLICATIONS, T_GPS_WORKFLOW_TYPES WTYPES, t_gps_workflow_states WS, T_GPS_NODETYPE_STATES NS, T_GPS_NODETYPES GN, T_APP_GROUPS APPGROUPS, T_CATEGORIES CATEGORIES WHERE APPLICATIONS.APPLICATION_ID = WTYPES.APPLICATION_ID AND WTYPES.WORKFLOW_TYPE_ID = WS.WORKFLOW_TYPE_ID AND WS.STATE_ID = NS.STATE_ID AND NS.NODETYPE_ID = GN.NODETYPE_ID AND APPLICATIONS.APPLICATION_ID = APPGROUPS.APP_ID AND APPGROUPS.CATEGORY_ID = CATEGORIES.CATEGORY_ID AND WTYPES.VISIBLE_FLAG = 'true' ORDER BY APPLICATION_GROUP
 
Possibly Referenced Tables/Views: