[Home] [Help]
View: PA_ADW_PROJECTS_B_V
View Text
SELECT PP.PROJECT_ID
, PP.PROJECT_TYPE
, PP.NAME
, PP.SEGMENT1
, PP.CARRYING_OUT_ORGANIZATION_ID
, PP.DESCRIPTION
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PP.ADW_NOTIFY_FLAG
FROM PA_PROJECTS PP
, PA_ADW_PRJ_TYPES_B_V PT
WHERE PP.PROJECT_TYPE = PT.PROJECT_TYPE
AND NVL(PP.TEMPLATE_FLAG
, 'N') != 'Y'
Columns
Name |
PROJECT_ID |
PROJECT_TYPE |
NAME |
SEGMENT1 |
CARRYING_OUT_ORGANIZATION_ID |
DESCRIPTION |
USER_COL1 |
USER_COL2 |
USER_COL3 |
USER_COL4 |
USER_COL5 |
USER_COL6 |
USER_COL7 |
USER_COL8 |
USER_COL9 |
USER_COL10 |
ADW_NOTIFY_FLAG |