VIEW: APPS.PER_PREVIOUS_EMPLOYERS1_DFV

Source

View Text - Preformatted

SELECT ROWID, PEM_INFORMATION_CATEGORY, (DECODE (PEM_INFORMATION_CATEGORY, 'SA', PEM_INFORMATION1, 'KW', PEM_INFORMATION1, 'AE', PEM_INFORMATION1, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'AE', TO_DATE(PEM_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'AE', PEM_INFORMATION3, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'AE', PEM_INFORMATION4, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'FR_PQH', PEM_INFORMATION2, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'FR_PQH', TO_DATE(PEM_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'HU', PEM_INFORMATION1, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', PEM_INFORMATION1, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION2), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', PEM_INFORMATION3, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', PEM_INFORMATION4, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', PEM_INFORMATION5, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', PEM_INFORMATION6, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION8), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION9), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION10), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION11), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION12), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION13), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION18), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION14), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION15), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION21), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION16), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION17), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION19), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION20), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION23), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION22), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION24), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'IN', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION25), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'JP', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION7), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'JP', PEM_INFORMATION1, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'JP', PEM_INFORMATION2, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'JP', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION3), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'JP', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION4), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'JP', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION5), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'JP', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION6), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'NO', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION1), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'NO', FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION2), NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'PL', PEM_INFORMATION1, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'PL', PEM_INFORMATION2, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'PL', PEM_INFORMATION3, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'PL', PEM_INFORMATION4, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'PL', PEM_INFORMATION5, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'PL', PEM_INFORMATION6, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'RU', PEM_INFORMATION1, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'RU', PEM_INFORMATION2, NULL)), (DECODE (PEM_INFORMATION_CATEGORY, 'RU', PEM_INFORMATION3, NULL)),  
 (DECODE (PEM_INFORMATION_CATEGORY,  
      'AE', PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3 || '.' || PEM_INFORMATION4,  
      'FR_PQH', PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3,  
      'HU', PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1,  
      'IN', PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3 || '.' || PEM_INFORMATION4 || '.' || PEM_INFORMATION5 || '.' || PEM_INFORMATION6 || '.' || PEM_INFORMATION8 || '.' || PEM_INFORMATION9 || '.' || PEM_INFORMATION10 || '.' || PEM_INFORMATION11 || '.' || PEM_INFORMATION12 || '.' || PEM_INFORMATION13 || '.' || PEM_INFORMATION18 || '.' || PEM_INFORMATION14 || '.' || PEM_INFORMATION15 || '.' || PEM_INFORMATION21 || '.' || PEM_INFORMATION16 || '.' || PEM_INFORMATION17 || '.' || PEM_INFORMATION19 || '.' || PEM_INFORMATION20 || '.' || PEM_INFORMATION23 || '.' || PEM_INFORMATION22 || '.' || PEM_INFORMATION24 || '.' || PEM_INFORMATION25,  
      'JP', PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION7 || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3 || '.' || PEM_INFORMATION4 || '.' || PEM_INFORMATION5 || '.' || PEM_INFORMATION6,  
      'KW', PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1,  
      'NO', PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2,  
      'PL', PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3 || '.' || PEM_INFORMATION4 || '.' || PEM_INFORMATION5 || '.' || PEM_INFORMATION6,  
      'RU', PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3,  
      'SA', PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1, NULL)) 
 FROM PER_PREVIOUS_EMPLOYERS

View Text - HTML Formatted

SELECT ROWID
, PEM_INFORMATION_CATEGORY
, (DECODE (PEM_INFORMATION_CATEGORY
, 'SA'
, PEM_INFORMATION1
, 'KW'
, PEM_INFORMATION1
, 'AE'
, PEM_INFORMATION1
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'AE'
, TO_DATE(PEM_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'AE'
, PEM_INFORMATION3
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'AE'
, PEM_INFORMATION4
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'FR_PQH'
, PEM_INFORMATION2
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'FR_PQH'
, TO_DATE(PEM_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'HU'
, PEM_INFORMATION1
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, PEM_INFORMATION1
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION2)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, PEM_INFORMATION3
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, PEM_INFORMATION4
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, PEM_INFORMATION5
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, PEM_INFORMATION6
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION8)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION9)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION10)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION11)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION12)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION13)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION18)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION14)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION15)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION21)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION16)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION17)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION19)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION20)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION23)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION22)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION24)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'IN'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION25)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'JP'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION7)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'JP'
, PEM_INFORMATION1
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'JP'
, PEM_INFORMATION2
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'JP'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION3)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'JP'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION4)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'JP'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION5)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'JP'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION6)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'NO'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION1)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'NO'
, FND_NUMBER.CANONICAL_TO_NUMBER(PEM_INFORMATION2)
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'PL'
, PEM_INFORMATION1
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'PL'
, PEM_INFORMATION2
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'PL'
, PEM_INFORMATION3
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'PL'
, PEM_INFORMATION4
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'PL'
, PEM_INFORMATION5
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'PL'
, PEM_INFORMATION6
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'RU'
, PEM_INFORMATION1
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'RU'
, PEM_INFORMATION2
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'RU'
, PEM_INFORMATION3
, NULL))
, (DECODE (PEM_INFORMATION_CATEGORY
, 'AE'
, PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3 || '.' || PEM_INFORMATION4
, 'FR_PQH'
, PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3
, 'HU'
, PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1
, 'IN'
, PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3 || '.' || PEM_INFORMATION4 || '.' || PEM_INFORMATION5 || '.' || PEM_INFORMATION6 || '.' || PEM_INFORMATION8 || '.' || PEM_INFORMATION9 || '.' || PEM_INFORMATION10 || '.' || PEM_INFORMATION11 || '.' || PEM_INFORMATION12 || '.' || PEM_INFORMATION13 || '.' || PEM_INFORMATION18 || '.' || PEM_INFORMATION14 || '.' || PEM_INFORMATION15 || '.' || PEM_INFORMATION21 || '.' || PEM_INFORMATION16 || '.' || PEM_INFORMATION17 || '.' || PEM_INFORMATION19 || '.' || PEM_INFORMATION20 || '.' || PEM_INFORMATION23 || '.' || PEM_INFORMATION22 || '.' || PEM_INFORMATION24 || '.' || PEM_INFORMATION25
, 'JP'
, PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION7 || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3 || '.' || PEM_INFORMATION4 || '.' || PEM_INFORMATION5 || '.' || PEM_INFORMATION6
, 'KW'
, PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1
, 'NO'
, PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2
, 'PL'
, PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3 || '.' || PEM_INFORMATION4 || '.' || PEM_INFORMATION5 || '.' || PEM_INFORMATION6
, 'RU'
, PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1 || '.' || PEM_INFORMATION2 || '.' || PEM_INFORMATION3
, 'SA'
, PEM_INFORMATION_CATEGORY || '.' || PEM_INFORMATION1
, NULL))
FROM PER_PREVIOUS_EMPLOYERS