[Home] [Help]
View: PA_ADW_PRJ_TYPES_B_V
View Text
SELECT PT.PROJECT_TYPE
, PT.DESCRIPTION
, PL.MEANING
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PT.ADW_NOTIFY_FLAG
FROM PA_PROJECT_TYPES PT
, PA_LOOKUPS PL
WHERE PL.LOOKUP_TYPE = 'ADW DIM LEVEL NAME'
AND PL.LOOKUP_CODE = 'ALL_PRJ_TYPES'
Columns
Name |
PROJECT_TYPE |
DESCRIPTION |
ALL_PROJECT_TYPES |
USER_COL1 |
USER_COL2 |
USER_COL3 |
USER_COL4 |
USER_COL5 |
USER_COL6 |
USER_COL7 |
USER_COL8 |
USER_COL9 |
USER_COL10 |
ADW_NOTIFY_FLAG |