PJT_PROJECT_STATUS_V

Details

• Schema: FUSION

• Object owner: PJT

• Object type: VIEW

Columns

Name
PROJECT_ID PROJECT_SYSTEM_STATUS_CODE

Query

SQL_Statement
SELECT p.PROJECT_ID, s.PROJECT_SYSTEM_STATUS_CODE FROM PJF_PROJECTS_ALL_B p, PJF_PROJECT_STATUSES_B s WHERE p.PROJECT_STATUS_CODE = s.PROJECT_STATUS_CODE