[Home] [Help]
View: PJMFV_PROJECT_MFG_PROJECTS
View Text
SELECT P.PROJECT_ID
, P.SEGMENT1
, P.NAME
, '_LA:1:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
FROM PA_PROJECTS_ALL P UNION SELECT S.PROJECT_ID
, S.PROJECT_NUMBER
, S.PROJECT_NAME
, '_LA:2:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
FROM PJM_SEIBAN_NUMBERS S WITH READ ONLY
Columns
| Name |
| PROJECT_ID |
| PROJECT_NUMBER |
| PROJECT_NAME |
| "_LA:PA_PROJECT_FLAG" |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
APPS.PJMFV_PROJECT_MFG_PROJECTS