VIEW: APPS.PJI_PERIOD_TYPES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'