View HLPDTEST.STATEGPS.GPS_EWKS_NODE_ROLES_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
USER_ID number 22  √  null
T_GPS_USERS.USER_ID Implied Constraint R
USER_NAME varchar2 255  √  null
ROLE_NAME varchar2 255  √  null
APPLICATION_NAME varchar2 255  √  null
WORKFLOW_TYPE varchar2 771  √  null
SET_NAME varchar2 771  √  null
FORM_NAME varchar2 771  √  null
OBJECT_TYPE varchar2 24  √  null

Analyzed at Tue Sep 22 01:05 IST 2020

View Definition:
SELECT T_USER_ROLES_APPLICATIONS_V.USER_ID, T_USER_ROLES_APPLICATIONS_V.USER_NAME, T_USER_ROLES_APPLICATIONS_V.ROLE_NAME, T_USER_ROLES_APPLICATIONS_V.APPLICATION_NAME, T_USER_ROLES_APPLICATIONS_V.WORKFLOW_TYPE, REGEXP_SUBSTR(T_USER_ROLES_APPLICATIONS_V.WORKFLOW_TYPE, '[^/]+') SET_NAME, REGEXP_SUBSTR(T_USER_ROLES_APPLICATIONS_V.WORKFLOW_TYPE, '[^/]+', 1, 2) FORM_NAME, decode(T_USER_ROLES_APPLICATIONS_V.OBJECT_TYPE, 'WORKFLOW/STATE/NODETYPES', 'Workflow state node', 'WORKFLOW/STATES', 'Workflow state', 'CATEGORY NAME', 'Folder', 'WORKFLOW', 'Workflow', 'CUSTOM SET', 'Custom module', 'VIEWER SET / REPORT', 'eWorksheet', 'BUILD/VIEW', 'Workbench', T_USER_ROLES_APPLICATIONS_V.OBJECT_TYPE) OBJECT_TYPE FROM STATEGPS.T_USER_ROLES_APPLICATIONS_V T_USER_ROLES_APPLICATIONS_V WHERE T_USER_ROLES_APPLICATIONS_V.OBJECT_TYPE != 'WORKFLOW' AND (T_USER_ROLES_APPLICATIONS_V.ROLE_NAME, T_USER_ROLES_APPLICATIONS_V.APPLICATION_NAME, T_USER_ROLES_APPLICATIONS_V.WORKFLOW_TYPE) NOT IN (SELECT DISTINCT T_ROLES.ROLE_NAME, T_GPS_APPLICATIONS.APPLICATION_NAME, T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME || ' / ' || T_GPS_WORKFLOW_STATES.STATE_NAME STATES FROM TAS.T_USERS T_USERS, TAS.T_USER_ROLES T_USER_ROLES, TAS.T_ROLES T_ROLES, STATEGPS.T_GPS_ROLES T_GPS_ROLES, STATEGPS.T_GPS_ROLE_APPLICATIONS T_GPS_ROLE_APPLICATIONS, STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS, STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES, STATEGPS.T_GPS_ROLE_WORKFLOW_TYPES T_GPS_ROLE_WORKFLOW_TYPES, STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES, STATEGPS.T_GPS_ROLE_STATES T_GPS_ROLE_STATES, STATEGPS.T_GPS_NODETYPES T_GPS_NODETYPES, STATEGPS.T_GPS_ROLE_NODETYPE_STATES T_GPS_ROLE_NODETYPE_STATES, STATEGPS.T_GPS_NODETYPE_STATES T_GPS_NODETYPE_STATES WHERE T_USERS.USER_NAME = T_USER_ROLES_APPLICATIONS_V.USER_NAME AND T_USERS.USER_ID = T_USER_ROLES.USER_ID AND T_USER_ROLES.ROLE_ID = T_ROLES.ROLE_ID AND T_ROLES.ROLE_NAME = T_GPS_ROLES.ROLE_NAME AND T_GPS_ROLE_APPLICATIONS.ROLE_ID = T_GPS_ROLES.ROLE_ID AND T_GPS_ROLE_APPLICATIONS.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID AND T_GPS_ROLE_WORKFLOW_TYPES.ROLE_APP_ID = T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID AND T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID AND T_GPS_ROLE_STATES.FROM_STATE_ID = T_GPS_WORKFLOW_STATES.STATE_ID AND T_GPS_ROLE_STATES.ROLE_WORKFLOW_TYPE_ID = T_GPS_ROLE_WORKFLOW_TYPES.ROLE_WORKFLOW_TYPE_ID AND T_GPS_ROLE_STATES.ROLE_STATE_ID = T_GPS_ROLE_NODETYPE_STATES.ROLE_STATE_ID AND T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID = T_GPS_ROLE_WORKFLOW_TYPES.WORKFLOW_TYPE_ID AND T_GPS_NODETYPE_STATES.STATE_ID = T_GPS_WORKFLOW_STATES.STATE_ID AND T_GPS_NODETYPES.NODETYPE_ID = T_GPS_ROLE_NODETYPE_STATES.NODETYPE_ID AND T_GPS_ROLE_NODETYPE_STATES.NODETYPE_ID = T_GPS_NODETYPE_STATES.NODETYPE_ID AND (T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL OR T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true') AND (T_GPS_WORKFLOW_TYPES.VISIBLE_FLAG IS NULL OR T_GPS_WORKFLOW_TYPES.VISIBLE_FLAG = 'true') AND (T_USERS.EFFECTIVE_END_DATE IS NULL OR (trunc(T_USERS.EFFECTIVE_END_DATE) >= trunc(SYSDATE)))) AND T_USER_ROLES_APPLICATIONS_V.OBJECT_TYPE = 'VIEWER SET / REPORT'
 
Possibly Referenced Tables/Views:


Close relationships: