GMS_ROLES_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
PROJECT_ROLE_NAME PROJECT_ROLE_ID START_DATE_ACTIVE END_DATE_ACTIVE SET_ID ROLE_SET_ID DESCRIPTION

Query

SQL_Statement
SELECT ProjectRoleTypePEO.PROJECT_ROLE_NAME, ProjectRoleTypePEO.PROJECT_ROLE_ID, ProjectRoleTypePEO.START_DATE_ACTIVE, ProjectRoleTypePEO.END_DATE_ACTIVE, to_number(0) as SET_ID, to_number(0) as ROLE_SET_ID, ProjectRoleTypePEO.DESCRIPTION FROM PJF_PROJ_ROLE_TYPES_VL ProjectRoleTypePEO