eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PER_POSITION_EXTRA_INFO1_DFV

Source

View Text - Preformatted


SELECT ROWID, POEI_INFORMATION_CATEGORY, (DECODE (POEI_INFORMATION_CATEGORY, 'DE_PQH_WRKPLC_STELLE_LINK', TO_DATE(POEI_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'DE_PQH_WRKPLC_STELLE_LINK', TO_DATE(POEI_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'DE_PQH_WRKPLC_STELLE_LINK', FND_NUMBER.CANONICAL_TO_NUMBER(POEI_INFORMATION3), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'DE_PQH_WRKPLC_STELLE_LINK', POEI_INFORMATION4, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_DESCRIPTION', TO_DATE(POEI_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_DESCRIPTION', TO_DATE(POEI_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_DESCRIPTION', POEI_INFORMATION3, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_INTERDISC', POEI_INFORMATION3, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_INTERDISC', POEI_INFORMATION4, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_INTERDISC', POEI_INFORMATION5, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_INTERDISC', POEI_INFORMATION6, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_LANGUAGE', POEI_INFORMATION3, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_LANGUAGE', POEI_INFORMATION4, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_LANGUAGE', POEI_INFORMATION5, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_LANGUAGE', POEI_INFORMATION6, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_LANGUAGE', POEI_INFORMATION7, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_LANGUAGE', POEI_INFORMATION9, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POSITION_LANGUAGE', TO_DATE(POEI_INFORMATION8, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_AFHR_DATA', POEI_INFORMATION3, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION5, 'GHR_US_POS_GRP1', POEI_INFORMATION3, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION8, 'GHR_US_POS_GRP1', POEI_INFORMATION4, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION5, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION6, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION7, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION8, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION9, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION20, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION10, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', FND_NUMBER.CANONICAL_TO_NUMBER(POEI_INFORMATION23), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION11, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION12, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION27, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION13, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION14, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION15, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION16, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION17, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION24, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION9, 'GHR_US_POS_GRP1', POEI_INFORMATION18, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION19, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION13, 'GHR_US_POS_GRP1', POEI_INFORMATION21, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP1', POEI_INFORMATION26, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION17, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION3, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION10, 'GHR_US_POS_GRP2', POEI_INFORMATION4, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', TO_DATE(POEI_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', TO_DATE(POEI_INFORMATION6, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION7, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION8, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION9, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION10, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION11, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION12, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION11, 'GHR_US_POS_GRP2', POEI_INFORMATION13, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION12, 'GHR_US_POS_GRP2', POEI_INFORMATION14, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION15, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION16, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION19, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', POEI_INFORMATION18, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP2', TO_DATE(POEI_INFORMATION20, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION21, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION3, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION5, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION4, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION6, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION7, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION8, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION19, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION20, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION9, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION10, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION11, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION12, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION13, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION14, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION15, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION16, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', POEI_INFORMATION17, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_GRP3', TO_DATE(POEI_INFORMATION18, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION3, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION4, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION14, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION6, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION7, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION15, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION16, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION17, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION18, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION19, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION20, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION21, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_OBLIG', TO_DATE(POEI_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_OBLIG', POEI_INFORMATION4, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_OBLIG', POEI_INFORMATION5, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_TELEWORK_INFO', POEI_INFORMATION1, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_TELEWORK_INFO', POEI_INFORMATION2, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_VALID_GRADE', POEI_INFORMATION14, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_VALID_GRADE', POEI_INFORMATION3, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_VALID_GRADE', POEI_INFORMATION4, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_VALID_GRADE', POEI_INFORMATION5, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_VALID_GRADE', POEI_INFORMATION6, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_VALID_GRADE', POEI_INFORMATION7, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_VALID_GRADE', POEI_INFORMATION8, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_VALID_GRADE', POEI_INFORMATION11, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_VALID_GRADE', POEI_INFORMATION12, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'GHR_US_POS_VALID_GRADE', POEI_INFORMATION13, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_FAMILY', POEI_INFORMATION3, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_OVERLAP', TO_DATE(POEI_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_OVERLAP', TO_DATE(POEI_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_RESERVED', TO_DATE(POEI_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_RESERVED', TO_DATE(POEI_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_RESERVED', POEI_INFORMATION5, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_RESERVED', FND_NUMBER.CANONICAL_TO_NUMBER(POEI_INFORMATION6), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_RESERVED', POEI_INFORMATION7, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_SEASONAL', TO_DATE(POEI_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_SEASONAL', TO_DATE(POEI_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_SUCCESSION_PLANNING', POEI_INFORMATION2, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PER_SUCCESSION_PLANNING', POEI_INFORMATION1, NULL)), (DECODE (POEI_INFORMATION_CATEGORY, 'PQH_POS_ROLE_ID', POEI_INFORMATION3, NULL)),  
 (DECODE (POEI_INFORMATION_CATEGORY,  
      'DE_PQH_WRKPLC_STELLE_LINK', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION1 || '.' || POEI_INFORMATION2 || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4,  
      'GHR_US_POSITION_DESCRIPTION', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION1 || '.' || POEI_INFORMATION2 || '.' || POEI_INFORMATION3,  
      'GHR_US_POSITION_INTERDISC', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6,  
      'GHR_US_POSITION_LANGUAGE', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION9 || '.' || POEI_INFORMATION8,  
      'GHR_US_POS_AFHR_DATA', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3,  
      'GHR_US_POS_GRP1', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION8 || '.' || POEI_INFORMATION9 || '.' || POEI_INFORMATION20 || '.' || POEI_INFORMATION10 || '.' || POEI_INFORMATION23 || '.' || POEI_INFORMATION11 || '.' || POEI_INFORMATION12 || '.' || POEI_INFORMATION27 || '.' || POEI_INFORMATION13 || '.' || POEI_INFORMATION14 || '.' || POEI_INFORMATION15 || '.' || POEI_INFORMATION16 || '.' || POEI_INFORMATION17 || '.' || POEI_INFORMATION24 || '.' || POEI_INFORMATION18 || '.' || POEI_INFORMATION19 || '.' || POEI_INFORMATION21 || '.' || POEI_INFORMATION26,  
      'GHR_US_POS_GRP2', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION17 || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION8 || '.' || POEI_INFORMATION9 || '.' || POEI_INFORMATION10 || '.' || POEI_INFORMATION11 || '.' || POEI_INFORMATION12 || '.' || POEI_INFORMATION13 || '.' || POEI_INFORMATION14 || '.' || POEI_INFORMATION15 || '.' || POEI_INFORMATION16 || '.' || POEI_INFORMATION19 || '.' || POEI_INFORMATION18 || '.' || POEI_INFORMATION20,  
      'GHR_US_POS_GRP3', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION21 || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION8 || '.' || POEI_INFORMATION19 || '.' || POEI_INFORMATION20 || '.' || POEI_INFORMATION9 || '.' || POEI_INFORMATION10 || '.' || POEI_INFORMATION11 || '.' || POEI_INFORMATION12 || '.' || POEI_INFORMATION13 || '.' || POEI_INFORMATION14 || '.' || POEI_INFORMATION15 || '.' || POEI_INFORMATION16 || '.' || POEI_INFORMATION17 || '.' || POEI_INFORMATION18,  
      'GHR_US_POS_MASS_ACTIONS', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION14 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION8 || '.' || POEI_INFORMATION9 || '.' || POEI_INFORMATION10 || '.' || POEI_INFORMATION11 || '.' || POEI_INFORMATION12 || '.' || POEI_INFORMATION13 || '.' || POEI_INFORMATION15 || '.' || POEI_INFORMATION16 || '.' || POEI_INFORMATION17 || '.' || POEI_INFORMATION18 || '.' || POEI_INFORMATION19 || '.' || POEI_INFORMATION20 || '.' || POEI_INFORMATION21,  
      'GHR_US_POS_OBLIG', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5,  
      'GHR_US_POS_TELEWORK_INFO', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION1 || '.' || POEI_INFORMATION2,  
      'GHR_US_POS_VALID_GRADE', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION14 || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION8 || '.' || POEI_INFORMATION11 || '.' || POEI_INFORMATION12 || '.' || POEI_INFORMATION13,  
      'PER_FAMILY', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3,  
      'PER_OVERLAP', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4,  
      'PER_RESERVED', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7,  
      'PER_SEASONAL', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4,  
      'PER_SUCCESSION_PLANNING', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION2 || '.' || POEI_INFORMATION1,  
      'PQH_POS_ROLE_ID', POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3, NULL)) 
 FROM PER_POSITION_EXTRA_INFO

View Text - HTML Formatted

SELECT ROWID
, POEI_INFORMATION_CATEGORY
, (DECODE (POEI_INFORMATION_CATEGORY
, 'DE_PQH_WRKPLC_STELLE_LINK'
, TO_DATE(POEI_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'DE_PQH_WRKPLC_STELLE_LINK'
, TO_DATE(POEI_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'DE_PQH_WRKPLC_STELLE_LINK'
, FND_NUMBER.CANONICAL_TO_NUMBER(POEI_INFORMATION3)
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'DE_PQH_WRKPLC_STELLE_LINK'
, POEI_INFORMATION4
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_DESCRIPTION'
, TO_DATE(POEI_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_DESCRIPTION'
, TO_DATE(POEI_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_DESCRIPTION'
, POEI_INFORMATION3
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_INTERDISC'
, POEI_INFORMATION3
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_INTERDISC'
, POEI_INFORMATION4
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_INTERDISC'
, POEI_INFORMATION5
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_INTERDISC'
, POEI_INFORMATION6
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_LANGUAGE'
, POEI_INFORMATION3
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_LANGUAGE'
, POEI_INFORMATION4
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_LANGUAGE'
, POEI_INFORMATION5
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_LANGUAGE'
, POEI_INFORMATION6
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_LANGUAGE'
, POEI_INFORMATION7
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_LANGUAGE'
, POEI_INFORMATION9
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POSITION_LANGUAGE'
, TO_DATE(POEI_INFORMATION8
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_AFHR_DATA'
, POEI_INFORMATION3
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION5
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION3
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION8
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION4
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION5
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION6
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION7
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION8
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION9
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION20
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION10
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, FND_NUMBER.CANONICAL_TO_NUMBER(POEI_INFORMATION23)
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION11
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION12
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION27
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION13
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION14
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION15
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION16
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION17
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION24
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION9
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION18
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION19
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION13
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION21
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION26
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION17
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION3
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION10
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION4
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, TO_DATE(POEI_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, TO_DATE(POEI_INFORMATION6
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION7
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION8
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION9
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION10
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION11
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION12
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION11
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION13
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION12
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION14
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION15
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION16
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION19
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION18
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP2'
, TO_DATE(POEI_INFORMATION20
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION21
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION3
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION5
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION4
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION6
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION7
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION8
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION19
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION20
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION9
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION10
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION11
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION12
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION13
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION14
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION15
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION16
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION17
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_GRP3'
, TO_DATE(POEI_INFORMATION18
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION3
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION4
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION14
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION6
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION7
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION15
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION16
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION17
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION18
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION19
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION20
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION21
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_OBLIG'
, TO_DATE(POEI_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_OBLIG'
, POEI_INFORMATION4
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_OBLIG'
, POEI_INFORMATION5
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_TELEWORK_INFO'
, POEI_INFORMATION1
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_TELEWORK_INFO'
, POEI_INFORMATION2
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_VALID_GRADE'
, POEI_INFORMATION14
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_VALID_GRADE'
, POEI_INFORMATION3
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_VALID_GRADE'
, POEI_INFORMATION4
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_VALID_GRADE'
, POEI_INFORMATION5
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_VALID_GRADE'
, POEI_INFORMATION6
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_VALID_GRADE'
, POEI_INFORMATION7
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_VALID_GRADE'
, POEI_INFORMATION8
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_VALID_GRADE'
, POEI_INFORMATION11
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_VALID_GRADE'
, POEI_INFORMATION12
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'GHR_US_POS_VALID_GRADE'
, POEI_INFORMATION13
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_FAMILY'
, POEI_INFORMATION3
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_OVERLAP'
, TO_DATE(POEI_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_OVERLAP'
, TO_DATE(POEI_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_RESERVED'
, TO_DATE(POEI_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_RESERVED'
, TO_DATE(POEI_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_RESERVED'
, POEI_INFORMATION5
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_RESERVED'
, FND_NUMBER.CANONICAL_TO_NUMBER(POEI_INFORMATION6)
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_RESERVED'
, POEI_INFORMATION7
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_SEASONAL'
, TO_DATE(POEI_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_SEASONAL'
, TO_DATE(POEI_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_SUCCESSION_PLANNING'
, POEI_INFORMATION2
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PER_SUCCESSION_PLANNING'
, POEI_INFORMATION1
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'PQH_POS_ROLE_ID'
, POEI_INFORMATION3
, NULL))
, (DECODE (POEI_INFORMATION_CATEGORY
, 'DE_PQH_WRKPLC_STELLE_LINK'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION1 || '.' || POEI_INFORMATION2 || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4
, 'GHR_US_POSITION_DESCRIPTION'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION1 || '.' || POEI_INFORMATION2 || '.' || POEI_INFORMATION3
, 'GHR_US_POSITION_INTERDISC'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6
, 'GHR_US_POSITION_LANGUAGE'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION9 || '.' || POEI_INFORMATION8
, 'GHR_US_POS_AFHR_DATA'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3
, 'GHR_US_POS_GRP1'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION8 || '.' || POEI_INFORMATION9 || '.' || POEI_INFORMATION20 || '.' || POEI_INFORMATION10 || '.' || POEI_INFORMATION23 || '.' || POEI_INFORMATION11 || '.' || POEI_INFORMATION12 || '.' || POEI_INFORMATION27 || '.' || POEI_INFORMATION13 || '.' || POEI_INFORMATION14 || '.' || POEI_INFORMATION15 || '.' || POEI_INFORMATION16 || '.' || POEI_INFORMATION17 || '.' || POEI_INFORMATION24 || '.' || POEI_INFORMATION18 || '.' || POEI_INFORMATION19 || '.' || POEI_INFORMATION21 || '.' || POEI_INFORMATION26
, 'GHR_US_POS_GRP2'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION17 || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION8 || '.' || POEI_INFORMATION9 || '.' || POEI_INFORMATION10 || '.' || POEI_INFORMATION11 || '.' || POEI_INFORMATION12 || '.' || POEI_INFORMATION13 || '.' || POEI_INFORMATION14 || '.' || POEI_INFORMATION15 || '.' || POEI_INFORMATION16 || '.' || POEI_INFORMATION19 || '.' || POEI_INFORMATION18 || '.' || POEI_INFORMATION20
, 'GHR_US_POS_GRP3'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION21 || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION8 || '.' || POEI_INFORMATION19 || '.' || POEI_INFORMATION20 || '.' || POEI_INFORMATION9 || '.' || POEI_INFORMATION10 || '.' || POEI_INFORMATION11 || '.' || POEI_INFORMATION12 || '.' || POEI_INFORMATION13 || '.' || POEI_INFORMATION14 || '.' || POEI_INFORMATION15 || '.' || POEI_INFORMATION16 || '.' || POEI_INFORMATION17 || '.' || POEI_INFORMATION18
, 'GHR_US_POS_MASS_ACTIONS'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION14 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION8 || '.' || POEI_INFORMATION9 || '.' || POEI_INFORMATION10 || '.' || POEI_INFORMATION11 || '.' || POEI_INFORMATION12 || '.' || POEI_INFORMATION13 || '.' || POEI_INFORMATION15 || '.' || POEI_INFORMATION16 || '.' || POEI_INFORMATION17 || '.' || POEI_INFORMATION18 || '.' || POEI_INFORMATION19 || '.' || POEI_INFORMATION20 || '.' || POEI_INFORMATION21
, 'GHR_US_POS_OBLIG'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5
, 'GHR_US_POS_TELEWORK_INFO'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION1 || '.' || POEI_INFORMATION2
, 'GHR_US_POS_VALID_GRADE'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION14 || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7 || '.' || POEI_INFORMATION8 || '.' || POEI_INFORMATION11 || '.' || POEI_INFORMATION12 || '.' || POEI_INFORMATION13
, 'PER_FAMILY'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3
, 'PER_OVERLAP'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4
, 'PER_RESERVED'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4 || '.' || POEI_INFORMATION5 || '.' || POEI_INFORMATION6 || '.' || POEI_INFORMATION7
, 'PER_SEASONAL'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3 || '.' || POEI_INFORMATION4
, 'PER_SUCCESSION_PLANNING'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION2 || '.' || POEI_INFORMATION1
, 'PQH_POS_ROLE_ID'
, POEI_INFORMATION_CATEGORY || '.' || POEI_INFORMATION3
, NULL))
FROM PER_POSITION_EXTRA_INFO