VIEW: APPS.HR_ALL_POSITIONS_F1_DFV

Source

View Text - Preformatted

SELECT ROWID, INFORMATION_CATEGORY, (DECODE (INFORMATION_CATEGORY, 'DE_PQH_ST', INFORMATION9, 'DE_PQH_SP', INFORMATION9, NULL)), (DECODE (INFORMATION_CATEGORY, 'DE_PQH_ST', INFORMATION10, 'DE_PQH_SP', INFORMATION10, NULL)), (DECODE (INFORMATION_CATEGORY, 'DE_PQH_ST', INFORMATION11, 'DE_PQH_SP', INFORMATION11, NULL)), (DECODE (INFORMATION_CATEGORY, 'DE_PQH_ST', INFORMATION12, 'DE_PQH_SP', INFORMATION12, NULL)), (DECODE (INFORMATION_CATEGORY, 'DE_PQH_ST', INFORMATION13, 'DE_PQH_SP', INFORMATION13, NULL)), (DECODE (INFORMATION_CATEGORY, 'DE_PQH_ST', INFORMATION14, 'DE_PQH_SP', INFORMATION14, NULL)), (DECODE (INFORMATION_CATEGORY, 'DE_PQH_ST', INFORMATION5, 'DE_PQH_SP', INFORMATION15, NULL)), (DECODE (INFORMATION_CATEGORY, 'DE_PQH_ST', INFORMATION8, 'DE_PQH_SP', INFORMATION16, NULL)), (DECODE (INFORMATION_CATEGORY, 'DE_PQH_ST', INFORMATION17, 'DE_PQH_SP', INFORMATION17, NULL)), INFORMATION2, INFORMATION4, INFORMATION6, INFORMATION7, INFORMATION15, INFORMATION16, INFORMATION1, INFORMATION2, INFORMATION4, INFORMATION5, INFORMATION6, INFORMATION7, INFORMATION8, INFORMATION9, INFORMATION10,  
 (DECODE (INFORMATION_CATEGORY,  
      'DE_PQH_SP', INFORMATION_CATEGORY || '.' || INFORMATION9 || '.' || INFORMATION10 || '.' || INFORMATION11 || '.' || INFORMATION12 || '.' || INFORMATION13 || '.' || INFORMATION14 || '.' || INFORMATION15 || '.' || INFORMATION16 || '.' || INFORMATION17,  
      'DE_PQH_ST', INFORMATION_CATEGORY || '.' || INFORMATION2 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7 || '.' || INFORMATION8 || '.' || INFORMATION9 || '.' || INFORMATION10 || '.' || INFORMATION11 || '.' || INFORMATION12 || '.' || INFORMATION13 || '.' || INFORMATION14 || '.' || INFORMATION15 || '.' || INFORMATION16 || '.' || INFORMATION17,  
      'DE_PQH_WP', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7 || '.' || INFORMATION8 || '.' || INFORMATION9 || '.' || INFORMATION10, NULL)) 
 FROM HR_ALL_POSITIONS_F

View Text - HTML Formatted

SELECT ROWID
, INFORMATION_CATEGORY
, (DECODE (INFORMATION_CATEGORY
, 'DE_PQH_ST'
, INFORMATION9
, 'DE_PQH_SP'
, INFORMATION9
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'DE_PQH_ST'
, INFORMATION10
, 'DE_PQH_SP'
, INFORMATION10
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'DE_PQH_ST'
, INFORMATION11
, 'DE_PQH_SP'
, INFORMATION11
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'DE_PQH_ST'
, INFORMATION12
, 'DE_PQH_SP'
, INFORMATION12
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'DE_PQH_ST'
, INFORMATION13
, 'DE_PQH_SP'
, INFORMATION13
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'DE_PQH_ST'
, INFORMATION14
, 'DE_PQH_SP'
, INFORMATION14
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'DE_PQH_ST'
, INFORMATION5
, 'DE_PQH_SP'
, INFORMATION15
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'DE_PQH_ST'
, INFORMATION8
, 'DE_PQH_SP'
, INFORMATION16
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'DE_PQH_ST'
, INFORMATION17
, 'DE_PQH_SP'
, INFORMATION17
, NULL))
, INFORMATION2
, INFORMATION4
, INFORMATION6
, INFORMATION7
, INFORMATION15
, INFORMATION16
, INFORMATION1
, INFORMATION2
, INFORMATION4
, INFORMATION5
, INFORMATION6
, INFORMATION7
, INFORMATION8
, INFORMATION9
, INFORMATION10
, (DECODE (INFORMATION_CATEGORY
, 'DE_PQH_SP'
, INFORMATION_CATEGORY || '.' || INFORMATION9 || '.' || INFORMATION10 || '.' || INFORMATION11 || '.' || INFORMATION12 || '.' || INFORMATION13 || '.' || INFORMATION14 || '.' || INFORMATION15 || '.' || INFORMATION16 || '.' || INFORMATION17
, 'DE_PQH_ST'
, INFORMATION_CATEGORY || '.' || INFORMATION2 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7 || '.' || INFORMATION8 || '.' || INFORMATION9 || '.' || INFORMATION10 || '.' || INFORMATION11 || '.' || INFORMATION12 || '.' || INFORMATION13 || '.' || INFORMATION14 || '.' || INFORMATION15 || '.' || INFORMATION16 || '.' || INFORMATION17
, 'DE_PQH_WP'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7 || '.' || INFORMATION8 || '.' || INFORMATION9 || '.' || INFORMATION10
, NULL))
FROM HR_ALL_POSITIONS_F