1. Tables and Views for Project Management
  2. PJT_PRIMARYPROJMANAGER_V

PJT_PRIMARYPROJMANAGER_V

Details

  • Schema: FUSION

  • Object owner: PJT

  • Object type: VIEW

Columns

Name

PROJECT_ID

RESOURCE_ID

DISPLAY_NAME

PERSON_ID

EMAIL

Query

SQL_Statement

SELECT distinct t1.project_id,

t2.resource_id,

t3.display_name,

t3.person_id,

t3.email

FROM pjf_proj_elements_b t1,

pjt_project_resource t2,

pjt_prj_enterprise_resource_vl t3,

pjt_project_roles_b t4

WHERE t1.object_type ='PJF_STRUCTURES'

AND (t1.element_type = 'EXECUTION' OR t1.element_type = 'FIN_EXEC')

AND t1.primary_resource_id=t2.resource_id(+)

AND t1.project_id = t2.project_id

AND t2.resource_id = t3.resource_id

AND t2.project_role_id = t4.project_role_id

AND t3.resource_class ='PEOPLE'

AND t4.project_role_id = 1