View: PJI_PERIOD_TYPES_V

Product:	PJI - Project Intelligence
Description:	This is an internal summarization view.
Implementation/DBA Data:	APPS.PJI_PERIOD_TYPES_V

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