Skip to content FND Design Data [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