View Definition - AP_WEB_PA_PROJECTS_V

 SELECT PROJECT_ID

, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
, START_DATE
, COMPLETION_DATE
, PROJECT_TYPE
, CARRYING_OUT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, O.NAME PROJECT_ORGANIZATION_NAME
, PROJECT_TYPE_CLASS_CODE 

FROM PA_PROJECTS_EXPEND_V P
, HR_ORGANIZATION_UNITS O
WHERE P.CARRYING_OUT_ORGANIZATION_ID = O.ORGANIZATION_ID