View HLPDTEST.STATEGPS.EIS_USER_PROJECT_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
PROJECT_NAME varchar2 255  √  null
USER_NAME varchar2 255  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
SELECT DISTINCT emsprod.SELECT_GROUP220.NAME PROJECT_NAME,SELECT_GROUP222.username USER_NAME from emsprod.EMS_PROJECT SELECT_GROUP220, emsprod.EMS_USER_PREFERENCE SELECT_GROUP221, emsprod.EIS_LOGIN SELECT_GROUP222 where SELECT_GROUP220.project_id = SELECT_GROUP221.project_id and to_char(SELECT_GROUP221.party_id) = SELECT_GROUP222.empid and (sysdate >= SELECT_GROUP220.enddate or SELECT_GROUP220.enddate is null) UNION --for getting TAB Applications SELECT DISTINCT SELECT_GROUP228.APPLICATION_NAME,SELECT_GROUP223.USER_NAME FROM tas.T_USERS SELECT_GROUP223, tas.T_ROLES SELECT_GROUP224, tas.T_USER_ROLES SELECT_GROUP225, stategps.T_GPS_ROLES SELECT_GROUP226, stategps.T_GPS_ROLE_APPLICATIONS SELECT_GROUP227, stategps.T_GPS_APPLICATIONS SELECT_GROUP228, stategps.T_GPS_APP_PROPERTIES SELECT_GROUP229 WHERE SELECT_GROUP223.USER_ID = SELECT_GROUP225.USER_ID AND SELECT_GROUP225.ROLE_ID = SELECT_GROUP224.ROLE_ID AND SELECT_GROUP226.ROLE_NAME = SELECT_GROUP224.ROLE_NAME AND SELECT_GROUP226.ROLE_ID = SELECT_GROUP227.ROLE_ID AND SELECT_GROUP227.APPLICATION_ID = SELECT_GROUP228.APPLICATION_ID AND SELECT_GROUP228.APPLICATION_ID = SELECT_GROUP229.APPLICATION_ID AND SELECT_GROUP229.PROPERTY_NAME = 'PROJECTPLAN_APPLICATION' AND SELECT_GROUP229.PROPERTY_VALUE = 'TRUE' AND (SELECT_GROUP228.VISIBLE_FLAG IS NULL OR SELECT_GROUP228.VISIBLE_FLAG = 'true')
 
Possibly Referenced Tables/Views: