VIEW: APPS.PJM_PROJECTS_ALL_OU_V

Source

View Text - Preformatted

SELECT P.PROJECT_ID , P.SEGMENT1 , P.NAME , P.DESCRIPTION , P.SEGMENT1 , P.START_DATE , P.COMPLETION_DATE , 2 , P.ORG_ID , P.PROJECT_STATUS_CODE , P.PROJECT_TYPE , P.CARRYING_OUT_ORGANIZATION_ID FROM PA_PROJECTS_ALL P WHERE P.PROJECT_TYPE <> 'AWARD_PROJECT' AND NVL( P.TEMPLATE_FLAG , 'N' ) <> 'Y' 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 , NULL , NULL , S.OPERATING_UNIT FROM PJM_SEIBAN_NUMBERS S

View Text - HTML Formatted

SELECT P.PROJECT_ID
, P.SEGMENT1
, P.NAME
, P.DESCRIPTION
, P.SEGMENT1
, P.START_DATE
, P.COMPLETION_DATE
, 2
, P.ORG_ID
, P.PROJECT_STATUS_CODE
, P.PROJECT_TYPE
, P.CARRYING_OUT_ORGANIZATION_ID
FROM PA_PROJECTS_ALL P
WHERE P.PROJECT_TYPE <> 'AWARD_PROJECT'
AND NVL( P.TEMPLATE_FLAG
, 'N' ) <> 'Y' 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
, NULL
, NULL
, S.OPERATING_UNIT
FROM PJM_SEIBAN_NUMBERS S