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
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
|
|
|