[Home] [Help]
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
Name |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_DESCRIPTION |
START_DATE |
COMPLETION_DATE |
PROJECT_STATUS |
PROJECT_TYPE |
PROJECT_ORGANIZATION_ID |
PROJECT_ORGANIZATION_NAME |