VIEW: APPS.PER_QUALIFICATIONS1_DFV

Source

View Text - Preformatted

SELECT ROWID, QUA_INFORMATION_CATEGORY, (DECODE (QUA_INFORMATION_CATEGORY, 'DE', TO_DATE(QUA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'DE', QUA_INFORMATION2, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'DE', QUA_INFORMATION3, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'DE', QUA_INFORMATION4, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'DE_PQH', QUA_INFORMATION1, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'FI', FND_NUMBER.CANONICAL_TO_NUMBER(QUA_INFORMATION1), NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'FI', QUA_INFORMATION2, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'FR', QUA_INFORMATION1, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'FR', TO_DATE(QUA_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'FR', QUA_INFORMATION3, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'FR', QUA_INFORMATION4, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'FR', QUA_INFORMATION5, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'GB', QUA_INFORMATION1, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'GB', QUA_INFORMATION2, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'GB', QUA_INFORMATION3, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'HU', QUA_INFORMATION1, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'HU', QUA_INFORMATION2, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'NO', QUA_INFORMATION1, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'NO', QUA_INFORMATION2, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'NO', QUA_INFORMATION3, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'NO', FND_NUMBER.CANONICAL_TO_NUMBER(QUA_INFORMATION4), NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'RU', QUA_INFORMATION1, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'RU', QUA_INFORMATION2, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'RU', QUA_INFORMATION3, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'RU', QUA_INFORMATION4, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'RU', QUA_INFORMATION5, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'RU', QUA_INFORMATION7, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'RU', QUA_INFORMATION6, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'SE', QUA_INFORMATION1, NULL)), (DECODE (QUA_INFORMATION_CATEGORY, 'SE', QUA_INFORMATION2, NULL)),  
 (DECODE (QUA_INFORMATION_CATEGORY,  
      'DE', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4,  
      'DE_PQH', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1,  
      'FI', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2,  
      'FR', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4 || '.' || QUA_INFORMATION5,  
      'GB', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3,  
      'HU', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2,  
      'NO', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4,  
      'RU', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4 || '.' || QUA_INFORMATION5 || '.' || QUA_INFORMATION7 || '.' || QUA_INFORMATION6,  
      'SE', QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2, NULL)) 
 FROM PER_QUALIFICATIONS

View Text - HTML Formatted

SELECT ROWID
, QUA_INFORMATION_CATEGORY
, (DECODE (QUA_INFORMATION_CATEGORY
, 'DE'
, TO_DATE(QUA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'DE'
, QUA_INFORMATION2
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'DE'
, QUA_INFORMATION3
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'DE'
, QUA_INFORMATION4
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'DE_PQH'
, QUA_INFORMATION1
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'FI'
, FND_NUMBER.CANONICAL_TO_NUMBER(QUA_INFORMATION1)
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'FI'
, QUA_INFORMATION2
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'FR'
, QUA_INFORMATION1
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(QUA_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'FR'
, QUA_INFORMATION3
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'FR'
, QUA_INFORMATION4
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'FR'
, QUA_INFORMATION5
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'GB'
, QUA_INFORMATION1
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'GB'
, QUA_INFORMATION2
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'GB'
, QUA_INFORMATION3
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'HU'
, QUA_INFORMATION1
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'HU'
, QUA_INFORMATION2
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'NO'
, QUA_INFORMATION1
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'NO'
, QUA_INFORMATION2
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'NO'
, QUA_INFORMATION3
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'NO'
, FND_NUMBER.CANONICAL_TO_NUMBER(QUA_INFORMATION4)
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'RU'
, QUA_INFORMATION1
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'RU'
, QUA_INFORMATION2
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'RU'
, QUA_INFORMATION3
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'RU'
, QUA_INFORMATION4
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'RU'
, QUA_INFORMATION5
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'RU'
, QUA_INFORMATION7
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'RU'
, QUA_INFORMATION6
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'SE'
, QUA_INFORMATION1
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'SE'
, QUA_INFORMATION2
, NULL))
, (DECODE (QUA_INFORMATION_CATEGORY
, 'DE'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4
, 'DE_PQH'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1
, 'FI'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2
, 'FR'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4 || '.' || QUA_INFORMATION5
, 'GB'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3
, 'HU'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2
, 'NO'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4
, 'RU'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2 || '.' || QUA_INFORMATION3 || '.' || QUA_INFORMATION4 || '.' || QUA_INFORMATION5 || '.' || QUA_INFORMATION7 || '.' || QUA_INFORMATION6
, 'SE'
, QUA_INFORMATION_CATEGORY || '.' || QUA_INFORMATION1 || '.' || QUA_INFORMATION2
, NULL))
FROM PER_QUALIFICATIONS