VIEW: APPS.PER_SUBJECTS_TAKEN1_DFV

Source

View Text - Preformatted

SELECT ROWID, SUB_INFORMATION_CATEGORY, SUB_INFORMATION1, SUB_INFORMATION2, SUB_INFORMATION3,  
 (DECODE (SUB_INFORMATION_CATEGORY,  
      'DE', SUB_INFORMATION_CATEGORY || '.' || SUB_INFORMATION1 || '.' || SUB_INFORMATION2 || '.' || SUB_INFORMATION3, NULL)) 
 FROM PER_SUBJECTS_TAKEN

View Text - HTML Formatted

SELECT ROWID
, SUB_INFORMATION_CATEGORY
, SUB_INFORMATION1
, SUB_INFORMATION2
, SUB_INFORMATION3
, (DECODE (SUB_INFORMATION_CATEGORY
, 'DE'
, SUB_INFORMATION_CATEGORY || '.' || SUB_INFORMATION1 || '.' || SUB_INFORMATION2 || '.' || SUB_INFORMATION3
, NULL))
FROM PER_SUBJECTS_TAKEN