VIEW: APPS.PER_JOBS1_DFV

Source

View Text - Preformatted

SELECT ROWID, JOB_INFORMATION_CATEGORY, JOB_INFORMATION9, (DECODE (JOB_INFORMATION_CATEGORY, 'CA', JOB_INFORMATION3, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'CA', JOB_INFORMATION1, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'CA', JOB_INFORMATION7, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'US', JOB_INFORMATION2, 'CA', JOB_INFORMATION2, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'US', JOB_INFORMATION4, 'CA', JOB_INFORMATION4, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'US', JOB_INFORMATION5, 'CA', JOB_INFORMATION5, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'US', JOB_INFORMATION6, 'CA', JOB_INFORMATION6, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'ES', JOB_INFORMATION1, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'ES', JOB_INFORMATION2, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'FR', JOB_INFORMATION1, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'FR', JOB_INFORMATION2, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'IN', JOB_INFORMATION1, 'HU', JOB_INFORMATION1, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'HU', JOB_INFORMATION2, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'HU', JOB_INFORMATION3, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'HU', JOB_INFORMATION4, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'NO', JOB_INFORMATION1, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'NO', JOB_INFORMATION2, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'SE', JOB_INFORMATION1, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'US', JOB_INFORMATION3, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'US', JOB_INFORMATION1, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'US', JOB_INFORMATION7, NULL)), (DECODE (JOB_INFORMATION_CATEGORY, 'US', JOB_INFORMATION8, NULL)),  
 JOB_INFORMATION9 || '.' || (DECODE (JOB_INFORMATION_CATEGORY,  
      'BF', JOB_INFORMATION_CATEGORY,  
      'CA', JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION3 || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION7 || '.' || JOB_INFORMATION2 || '.' || JOB_INFORMATION4 || '.' || JOB_INFORMATION5 || '.' || JOB_INFORMATION6,  
      'ES', JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION2,  
      'FR', JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION2,  
      'HU', JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION2 || '.' || JOB_INFORMATION3 || '.' || JOB_INFORMATION4,  
      'IN', JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1,  
      'NO', JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION2,  
      'SE', JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1,  
      'US', JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION3 || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION7 || '.' || JOB_INFORMATION2 || '.' || JOB_INFORMATION4 || '.' || JOB_INFORMATION5 || '.' || JOB_INFORMATION6 || '.' || JOB_INFORMATION8, NULL)) 
 FROM PER_JOBS

View Text - HTML Formatted

SELECT ROWID
, JOB_INFORMATION_CATEGORY
, JOB_INFORMATION9
, (DECODE (JOB_INFORMATION_CATEGORY
, 'CA'
, JOB_INFORMATION3
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'CA'
, JOB_INFORMATION1
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'CA'
, JOB_INFORMATION7
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'US'
, JOB_INFORMATION2
, 'CA'
, JOB_INFORMATION2
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'US'
, JOB_INFORMATION4
, 'CA'
, JOB_INFORMATION4
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'US'
, JOB_INFORMATION5
, 'CA'
, JOB_INFORMATION5
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'US'
, JOB_INFORMATION6
, 'CA'
, JOB_INFORMATION6
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'ES'
, JOB_INFORMATION1
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'ES'
, JOB_INFORMATION2
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'FR'
, JOB_INFORMATION1
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'FR'
, JOB_INFORMATION2
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'IN'
, JOB_INFORMATION1
, 'HU'
, JOB_INFORMATION1
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'HU'
, JOB_INFORMATION2
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'HU'
, JOB_INFORMATION3
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'HU'
, JOB_INFORMATION4
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'NO'
, JOB_INFORMATION1
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'NO'
, JOB_INFORMATION2
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'SE'
, JOB_INFORMATION1
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'US'
, JOB_INFORMATION3
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'US'
, JOB_INFORMATION1
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'US'
, JOB_INFORMATION7
, NULL))
, (DECODE (JOB_INFORMATION_CATEGORY
, 'US'
, JOB_INFORMATION8
, NULL))
, JOB_INFORMATION9 || '.' || (DECODE (JOB_INFORMATION_CATEGORY
, 'BF'
, JOB_INFORMATION_CATEGORY
, 'CA'
, JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION3 || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION7 || '.' || JOB_INFORMATION2 || '.' || JOB_INFORMATION4 || '.' || JOB_INFORMATION5 || '.' || JOB_INFORMATION6
, 'ES'
, JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION2
, 'FR'
, JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION2
, 'HU'
, JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION2 || '.' || JOB_INFORMATION3 || '.' || JOB_INFORMATION4
, 'IN'
, JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1
, 'NO'
, JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION2
, 'SE'
, JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION1
, 'US'
, JOB_INFORMATION_CATEGORY || '.' || JOB_INFORMATION3 || '.' || JOB_INFORMATION1 || '.' || JOB_INFORMATION7 || '.' || JOB_INFORMATION2 || '.' || JOB_INFORMATION4 || '.' || JOB_INFORMATION5 || '.' || JOB_INFORMATION6 || '.' || JOB_INFORMATION8
, NULL))
FROM PER_JOBS