[Home] [Help]
View: PJI_PERIOD_TYPES_V
Product: | PJI - Project Intelligence(Obsolete) |
Description: | This is an internal summarization view. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT LOOKUP_CODE ID
, MEANING VALUE
, DECODE(LOOKUP_CODE
, 'FII_TIME_WEEK'
, 0
, 'FII_TIME_PA_PERIOD'
, 1
, DECODE(SUBSTR(LOOKUP_CODE
, 10
, 1)
, 'C'
, 1
, 0)) GLOBAL_DISP_FLAG
FROM PJI_LOOKUPS
WHERE LOOKUP_TYPE = 'PJI_PERIOD_TYPE_LIST'
Columns
Name |
ID |
VALUE |
GLOBAL_DISP_FLAG |