PJT_PROJ_STATUS_MEANING

Details

Schema: FUSION
Object owner: PJT
Object type: VIEW

Columns

Name
PROJECT_ID PROJECT_STATUS_CODE PROJECT_SYSTEM_STATUS_CODE MEANING

Name

PROJECT_ID

PROJECT_STATUS_CODE

PROJECT_SYSTEM_STATUS_CODE

MEANING

Query

SQL_Statement
SELECT p.PROJECT_ID, p.PROJECT_STATUS_CODE, s.PROJECT_SYSTEM_STATUS_CODE, k.MEANING FROM PJF_PROJECTS_ALL_B p, PJF_PROJECT_STATUSES_B s, PJT_LOOKUPS k WHERE p.PROJECT_STATUS_CODE = s.PROJECT_STATUS_CODE AND s.PROJECT_SYSTEM_STATUS_CODE = k.LOOKUP_CODE AND (k.LOOKUP_TYPE = 'PJT_PROJECT_SYS_STATUS_PRI' OR k.LOOKUP_TYPE = 'PJT_PROJECT_SYS_STATUS_SEC')

SQL_Statement

SELECT p.PROJECT_ID, p.PROJECT_STATUS_CODE, s.PROJECT_SYSTEM_STATUS_CODE, k.MEANING

FROM PJF_PROJECTS_ALL_B p, PJF_PROJECT_STATUSES_B s, PJT_LOOKUPS k

WHERE p.PROJECT_STATUS_CODE = s.PROJECT_STATUS_CODE AND s.PROJECT_SYSTEM_STATUS_CODE = k.LOOKUP_CODE AND (k.LOOKUP_TYPE = 'PJT_PROJECT_SYS_STATUS_PRI' OR k.LOOKUP_TYPE = 'PJT_PROJECT_SYS_STATUS_SEC')