VIEW: APPS.ICX_EDM_PROJECT_V

Source

View Text - Preformatted

SELECT PROJ.PROJECT_ID , PROJ.SEGMENT1 , PROJ.NAME , PROJ.DESCRIPTION , PROJ.CARRYING_OUT_ORGANIZATION_ID ORGANIZATION_ID , ORG.NAME , NULL , PROJ.PROJECT_TYPE , PROJ.PROJECT_STATUS_CODE STATUS , PS.PROJECT_STATUS_NAME , PROJ.START_DATE START_DATE , PROJ.COMPLETION_DATE END_DATE , NULL FROM PA_PROJECTS_ALL PROJ , HR_ORGANIZATION_UNITS ORG , PA_PROJECT_STATUSES PS WHERE PROJ.CARRYING_OUT_ORGANIZATION_ID = ORG.ORGANIZATION_ID(+) AND PROJ.TEMPLATE_FLAG != 'Y' AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE UNION SELECT SEIB.PROJECT_ID , SEIB.PROJECT_NUMBER , SEIB.PROJECT_NAME , SEIB.PROJECT_NAME PROJECT_DESCRIPTION , SEIB.OPERATING_UNIT ORGANIZATION_ID , ORG.NAME , NULL , TO_CHAR(NULL) , TO_CHAR(NULL) , TO_CHAR(NULL) , TO_DATE(NULL) PROJECT_START_DATE , TO_DATE(NULL) PROJECT_END_DATE , TO_CHAR(NULL) LAST_ACCUMULATED_PERIOD FROM PJM_SEIBAN_NUMBERS SEIB , HR_ORGANIZATION_UNITS ORG WHERE ORG.ORGANIZATION_ID(+) = SEIB.OPERATING_UNIT

View Text - HTML Formatted

SELECT PROJ.PROJECT_ID
, PROJ.SEGMENT1
, PROJ.NAME
, PROJ.DESCRIPTION
, PROJ.CARRYING_OUT_ORGANIZATION_ID ORGANIZATION_ID
, ORG.NAME
, NULL
, PROJ.PROJECT_TYPE
, PROJ.PROJECT_STATUS_CODE STATUS
, PS.PROJECT_STATUS_NAME
, PROJ.START_DATE START_DATE
, PROJ.COMPLETION_DATE END_DATE
, NULL
FROM PA_PROJECTS_ALL PROJ
, HR_ORGANIZATION_UNITS ORG
, PA_PROJECT_STATUSES PS
WHERE PROJ.CARRYING_OUT_ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)
AND PROJ.TEMPLATE_FLAG != 'Y'
AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE UNION SELECT SEIB.PROJECT_ID
, SEIB.PROJECT_NUMBER
, SEIB.PROJECT_NAME
, SEIB.PROJECT_NAME PROJECT_DESCRIPTION
, SEIB.OPERATING_UNIT ORGANIZATION_ID
, ORG.NAME
, NULL
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_DATE(NULL) PROJECT_START_DATE
, TO_DATE(NULL) PROJECT_END_DATE
, TO_CHAR(NULL) LAST_ACCUMULATED_PERIOD
FROM PJM_SEIBAN_NUMBERS SEIB
, HR_ORGANIZATION_UNITS ORG
WHERE ORG.ORGANIZATION_ID(+) = SEIB.OPERATING_UNIT