VIEW: APPS.PER_ABS_ATTENDANCE_TYPES1_DFV

Source

View Text - Preformatted

SELECT ROWID, INFORMATION_CATEGORY, (DECODE (INFORMATION_CATEGORY, 'DK', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'FI', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'MX', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'SE', INFORMATION1, 'NO', INFORMATION1, NULL)),  
 (DECODE (INFORMATION_CATEGORY,  
      'DK', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'FI', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'MX', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'NO', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'SE', INFORMATION_CATEGORY || '.' || INFORMATION1, NULL)) 
 FROM PER_ABSENCE_ATTENDANCE_TYPES

View Text - HTML Formatted

SELECT ROWID
, INFORMATION_CATEGORY
, (DECODE (INFORMATION_CATEGORY
, 'DK'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FI'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'MX'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'SE'
, INFORMATION1
, 'NO'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'DK'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'FI'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'MX'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'NO'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'SE'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, NULL))
FROM PER_ABSENCE_ATTENDANCE_TYPES