View: PJM_PROJECTS_V

Product:	PJM - Project Manufacturing
Description:	All Project / Seiban view
Implementation/DBA Data:	APPS.PJM_PROJECTS_V

View Text

SELECT P.PROJECT_ID
, P.PROJECT_NUMBER
, P.PROJECT_NAME
, P.PROJECT_DESCRIPTION
, P.PROJECT_NUMBER_SORT_ORDER
, P.START_DATE
, P.COMPLETION_DATE
, 2
, P.PROJECT_OU
FROM PA_PROJECTS_EXPEND_V P UNION ALL SELECT S.PROJECT_ID
, S.PROJECT_NUMBER
, S.PROJECT_NAME
, S.PROJECT_NAME
, S.PROJECT_NUMBER
, TO_DATE(NULL)
, TO_DATE(NULL)
, 1
, S.OPERATING_UNIT
FROM PJM_SEIBAN_NUMBERS S

Columns