View: PJM_PROJECT_PROJ_V

Product:	PJM - Project Manufacturing
Description:	Combined project and seiban information for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_PROJ_V

View Text

SELECT PROJ.PROJECT_ID
, PROJ.PROJECT_NUMBER
, PROJ.PROJECT_NAME
, PROJ.PROJECT_DESCRIPTION
, PROJ.START_DATE
, PROJ.COMPLETION_DATE
, PS.PROJECT_STATUS_NAME
, PROJ.PROJECT_TYPE
, PROJ.CARRYING_OUT_ORGANIZATION_ID
, ORG.NAME
FROM PA_PROJECTS_ALL_BASIC_V PROJ
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, PA_PROJECT_STATUSES PS
WHERE ORG.ORGANIZATION_ID (+) = PROJ.CARRYING_OUT_ORGANIZATION_ID
AND ORG.LANGUAGE (+) = USERENV('LANG')
AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE UNION ALL SELECT SEIB.PROJECT_ID
, SEIB.PROJECT_NUMBER
, SEIB.PROJECT_NAME
, SEIB.PROJECT_NAME
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, SEIB.OPERATING_UNIT
, ORG.NAME
FROM PJM_SEIBAN_NUMBERS SEIB
, HR_ALL_ORGANIZATION_UNITS_TL ORG
WHERE ORG.ORGANIZATION_ID (+) = SEIB.OPERATING_UNIT
AND ORG.LANGUAGE (+) = USERENV('LANG')

Columns