[Home] [Help]
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
Name |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_DESCRIPTION |
PROJECT_NUMBER_SORT_ORDER |
START_DATE |
COMPLETION_DATE |
SEIBAN_NUMBER_FLAG |
OPERATING_UNIT |