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.HR_LOCATION_EXTRA_INFO1_DFV

Source

View Text - Preformatted


SELECT ROWID, LEI_INFORMATION_CATEGORY, (DECODE (LEI_INFORMATION_CATEGORY, 'CLM_OFFICE_CODE', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'CLM_OFFICE_CODE', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'CLM_OFFICE_CODE', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'CLM_OFFICE_CODE', LEI_INFORMATION4, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'CLM_OFFICE_CODE', LEI_INFORMATION5, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'CLM_OFFICE_CODE', LEI_INFORMATION6, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'CLM_OFFICE_CODE', LEI_INFORMATION7, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'CLM_OFFICE_CODE', LEI_INFORMATION8, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'CLM_OFFICE_CODE', LEI_INFORMATION9, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'CLM_OFFICE_CODE', LEI_INFORMATION10, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'DE_LOCATION_INFO', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'DK_LOCATION_INFO', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION1), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION3), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION4), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION5), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION6), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION7), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION8), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION9), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION10), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION11), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION12), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION13), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION14), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION15), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION16), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Archive Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION17), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'VETS-100 Specific Information', LEI_INFORMATION1, 'EEO-1 Specific Information', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'ZA_SARS_ADDRESS', LEI_INFORMATION1, 'VETS-100 Specific Information', LEI_INFORMATION2, 'NM SQWL Unit Number', LEI_INFORMATION1, 'EEO-1 Specific Information', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Specific Information', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Specific Information', LEI_INFORMATION4, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Specific Information', LEI_INFORMATION9, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Specific Information', LEI_INFORMATION5, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Specific Information', LEI_INFORMATION6, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Specific Information', LEI_INFORMATION7, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'EEO-1 Specific Information', LEI_INFORMATION8, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Establishment Information', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Establishment Information', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Establishment Information', LEI_INFORMATION4, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Establishment Information', LEI_INFORMATION6, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Establishment Information', LEI_INFORMATION10, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'GHR_US_LOC_INFORMATION', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'HR_SELF_SERVICE_LOC_PREFERENCE', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'HR_SELF_SERVICE_LOC_PREFERENCE', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'HR_SELF_SERVICE_LOC_PREFERENCE', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'HR_SELF_SERVICE_LOC_PREFERENCE', LEI_INFORMATION4, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'HR_SELF_SERVICE_LOC_PREFERENCE', LEI_INFORMATION5, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'HR_SELF_SERVICE_LOC_PREFERENCE', TO_DATE(LEI_INFORMATION6, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'HR_SELF_SERVICE_LOC_PREFERENCE', LEI_INFORMATION13, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'HU_MAILING_ADDRESS', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'ZA_SARS_ADDRESS', LEI_INFORMATION7, 'NL_POSTAL_ADDRESS', LEI_INFORMATION5, 'HU_MAILING_ADDRESS', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'ZA_SARS_ADDRESS', LEI_INFORMATION6, 'HU_MAILING_ADDRESS', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_MAILING_ADDRESS_INFO', LEI_INFORMATION5, 'HU_MAILING_ADDRESS', LEI_INFORMATION4, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'HU_MAILING_ADDRESS', LEI_INFORMATION5, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'HU_MAILING_ADDRESS', LEI_INFORMATION6, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'HU_MAILING_ADDRESS', LEI_INFORMATION7, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'ZA_SARS_ADDRESS', LEI_INFORMATION8, 'PQP_GB_MAILING_ADDRESS_INFO', LEI_INFORMATION7, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION13, 'NL_POSTAL_ADDRESS', LEI_INFORMATION8, 'HU_MAILING_ADDRESS', LEI_INFORMATION8, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_MAILING_ADDRESS_INFO', LEI_INFORMATION8, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION14, 'NL_POSTAL_ADDRESS', LEI_INFORMATION11, 'HU_MAILING_ADDRESS', LEI_INFORMATION9, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_MAILING_ADDRESS_INFO', LEI_INFORMATION9, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION16, 'NL_POSTAL_ADDRESS', LEI_INFORMATION12, 'HU_MAILING_ADDRESS', LEI_INFORMATION10, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Multi Work Site Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION1), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Multi Work Site Information', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Multi Work Site Information', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Multi Work Site Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION4), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Multi Work Site Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION5), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Multi Work Site Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION6), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'Multi Work Site Information', LEI_INFORMATION7, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'RU_POSTAL_ADDRESS', LEI_INFORMATION6, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION5, 'NL_POSTAL_ADDRESS', LEI_INFORMATION13, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'NL_POSTAL_ADDRESS', LEI_INFORMATION14, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION4, 'NL_POSTAL_ADDRESS', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'NL_POSTAL_ADDRESS', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'NL_POSTAL_ADDRESS', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'NL_POSTAL_ADDRESS', LEI_INFORMATION4, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'RU_POSTAL_ADDRESS', LEI_INFORMATION4, 'NL_POSTAL_ADDRESS', LEI_INFORMATION6, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION9, 'NL_POSTAL_ADDRESS', LEI_INFORMATION7, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'NL_POSTAL_ADDRESS', LEI_INFORMATION9, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'NL_POSTAL_ADDRESS', LEI_INFORMATION10, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PER_GEO_HIER_NODE_MAP', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PL_CORRESPONDENCE_ADDRESS', TO_DATE(LEI_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PL_CORRESPONDENCE_ADDRESS', TO_DATE(LEI_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION6, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_MAILING_ADDRESS_INFO', LEI_INFORMATION6, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION7, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_MAILING_ADDRESS_INFO', LEI_INFORMATION4, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION8, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION10, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION11, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION12, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION15, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION17, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_EDU_ESTB_INFO', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_EDU_ESTB_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION2), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_EDU_ESTB_INFO', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_EDU_ESTB_INFO', LEI_INFORMATION4, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_EDU_ESTB_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION5), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_EDU_ESTB_INFO', LEI_INFORMATION6, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_MAILING_ADDRESS_INFO', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_MAILING_ADDRESS_INFO', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_MAILING_ADDRESS_INFO', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_PENSERV_LOCATION_INFO', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'PQP_GB_PENSERV_LOCATION_INFO', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'RU_POSTAL_ADDRESS', FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION1), NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'RU_POSTAL_ADDRESS', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'RU_POSTAL_ADDRESS', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'RU_POSTAL_ADDRESS', LEI_INFORMATION5, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'RU_POSTAL_ADDRESS', LEI_INFORMATION7, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'RU_POSTAL_ADDRESS', LEI_INFORMATION8, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'SE_ALECTA_DETAILS', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'US_LOC_REP_PREFERENCES', LEI_INFORMATION1, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'ZA_SARS_ADDRESS', LEI_INFORMATION2, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'ZA_SARS_ADDRESS', LEI_INFORMATION3, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'ZA_SARS_ADDRESS', LEI_INFORMATION4, NULL)), (DECODE (LEI_INFORMATION_CATEGORY, 'ZA_SARS_ADDRESS', LEI_INFORMATION5, NULL)),  
 (DECODE (LEI_INFORMATION_CATEGORY,  
      'CLM_OFFICE_CODE', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION10,  
      'DE_LOCATION_INFO', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1,  
      'DK_LOCATION_INFO', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1,  
      'EEO-1 Archive Information', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION10 || '.' || LEI_INFORMATION11 || '.' || LEI_INFORMATION12 || '.' || LEI_INFORMATION13 || '.' || LEI_INFORMATION14 || '.' || LEI_INFORMATION15 || '.' || LEI_INFORMATION16 || '.' || LEI_INFORMATION17,  
      'EEO-1 Specific Information', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8,  
      'Establishment Information', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION10,  
      'GHR_US_LOC_INFORMATION', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION3,  
      'HR_SELF_SERVICE_LOC_PREFERENCE', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION13,  
      'HU_MAILING_ADDRESS', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION10,  
      'Multi Work Site Information', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7,  
      'NL_POSTAL_ADDRESS', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION13 || '.' || LEI_INFORMATION14 || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION10 || '.' || LEI_INFORMATION11 || '.' || LEI_INFORMATION12,  
      'NM SQWL Unit Number', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1,  
      'PER_GEO_HIER_NODE_MAP', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1,  
      'PL_CORRESPONDENCE_ADDRESS', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION10 || '.' || LEI_INFORMATION11 || '.' || LEI_INFORMATION12 || '.' || LEI_INFORMATION13 || '.' || LEI_INFORMATION14 || '.' || LEI_INFORMATION15 || '.' || LEI_INFORMATION16 || '.' || LEI_INFORMATION17,  
      'PQP_GB_EDU_ESTB_INFO', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6,  
      'PQP_GB_MAILING_ADDRESS_INFO', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9,  
      'PQP_GB_PENSERV_LOCATION_INFO', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2,  
      'RU_POSTAL_ADDRESS', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8,  
      'SE_ALECTA_DETAILS', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1,  
      'US_LOC_REP_PREFERENCES', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1,  
      'VETS-100 Specific Information', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2,  
      'ZA_SARS_ADDRESS', LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8, NULL)) 
 FROM HR_LOCATION_EXTRA_INFO

View Text - HTML Formatted

SELECT ROWID
, LEI_INFORMATION_CATEGORY
, (DECODE (LEI_INFORMATION_CATEGORY
, 'CLM_OFFICE_CODE'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'CLM_OFFICE_CODE'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'CLM_OFFICE_CODE'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'CLM_OFFICE_CODE'
, LEI_INFORMATION4
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'CLM_OFFICE_CODE'
, LEI_INFORMATION5
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'CLM_OFFICE_CODE'
, LEI_INFORMATION6
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'CLM_OFFICE_CODE'
, LEI_INFORMATION7
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'CLM_OFFICE_CODE'
, LEI_INFORMATION8
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'CLM_OFFICE_CODE'
, LEI_INFORMATION9
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'CLM_OFFICE_CODE'
, LEI_INFORMATION10
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'DE_LOCATION_INFO'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'DK_LOCATION_INFO'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION1)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION3)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION4)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION5)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION6)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION7)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION8)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION9)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION10)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION11)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION12)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION13)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION14)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION15)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION16)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 ARCHIVE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION17)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'VETS-100 SPECIFIC INFORMATION'
, LEI_INFORMATION1
, 'EEO-1 SPECIFIC INFORMATION'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ZA_SARS_ADDRESS'
, LEI_INFORMATION1
, 'VETS-100 SPECIFIC INFORMATION'
, LEI_INFORMATION2
, 'NM SQWL UNIT NUMBER'
, LEI_INFORMATION1
, 'EEO-1 SPECIFIC INFORMATION'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 SPECIFIC INFORMATION'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 SPECIFIC INFORMATION'
, LEI_INFORMATION4
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 SPECIFIC INFORMATION'
, LEI_INFORMATION9
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 SPECIFIC INFORMATION'
, LEI_INFORMATION5
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 SPECIFIC INFORMATION'
, LEI_INFORMATION6
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 SPECIFIC INFORMATION'
, LEI_INFORMATION7
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'EEO-1 SPECIFIC INFORMATION'
, LEI_INFORMATION8
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ESTABLISHMENT INFORMATION'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ESTABLISHMENT INFORMATION'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ESTABLISHMENT INFORMATION'
, LEI_INFORMATION4
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ESTABLISHMENT INFORMATION'
, LEI_INFORMATION6
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ESTABLISHMENT INFORMATION'
, LEI_INFORMATION10
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'GHR_US_LOC_INFORMATION'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'HR_SELF_SERVICE_LOC_PREFERENCE'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'HR_SELF_SERVICE_LOC_PREFERENCE'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'HR_SELF_SERVICE_LOC_PREFERENCE'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'HR_SELF_SERVICE_LOC_PREFERENCE'
, LEI_INFORMATION4
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'HR_SELF_SERVICE_LOC_PREFERENCE'
, LEI_INFORMATION5
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'HR_SELF_SERVICE_LOC_PREFERENCE'
, TO_DATE(LEI_INFORMATION6
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'HR_SELF_SERVICE_LOC_PREFERENCE'
, LEI_INFORMATION13
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'HU_MAILING_ADDRESS'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ZA_SARS_ADDRESS'
, LEI_INFORMATION7
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION5
, 'HU_MAILING_ADDRESS'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ZA_SARS_ADDRESS'
, LEI_INFORMATION6
, 'HU_MAILING_ADDRESS'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_MAILING_ADDRESS_INFO'
, LEI_INFORMATION5
, 'HU_MAILING_ADDRESS'
, LEI_INFORMATION4
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'HU_MAILING_ADDRESS'
, LEI_INFORMATION5
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'HU_MAILING_ADDRESS'
, LEI_INFORMATION6
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'HU_MAILING_ADDRESS'
, LEI_INFORMATION7
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ZA_SARS_ADDRESS'
, LEI_INFORMATION8
, 'PQP_GB_MAILING_ADDRESS_INFO'
, LEI_INFORMATION7
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION13
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION8
, 'HU_MAILING_ADDRESS'
, LEI_INFORMATION8
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_MAILING_ADDRESS_INFO'
, LEI_INFORMATION8
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION14
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION11
, 'HU_MAILING_ADDRESS'
, LEI_INFORMATION9
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_MAILING_ADDRESS_INFO'
, LEI_INFORMATION9
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION16
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION12
, 'HU_MAILING_ADDRESS'
, LEI_INFORMATION10
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'MULTI WORK SITE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION1)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'MULTI WORK SITE INFORMATION'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'MULTI WORK SITE INFORMATION'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'MULTI WORK SITE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION4)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'MULTI WORK SITE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION5)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'MULTI WORK SITE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION6)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'MULTI WORK SITE INFORMATION'
, LEI_INFORMATION7
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'RU_POSTAL_ADDRESS'
, LEI_INFORMATION6
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION5
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION13
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION14
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION4
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION4
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'RU_POSTAL_ADDRESS'
, LEI_INFORMATION4
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION6
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION9
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION7
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION9
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION10
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PER_GEO_HIER_NODE_MAP'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PL_CORRESPONDENCE_ADDRESS'
, TO_DATE(LEI_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PL_CORRESPONDENCE_ADDRESS'
, TO_DATE(LEI_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION6
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_MAILING_ADDRESS_INFO'
, LEI_INFORMATION6
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION7
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_MAILING_ADDRESS_INFO'
, LEI_INFORMATION4
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION8
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION10
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION11
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION12
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION15
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION17
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_EDU_ESTB_INFO'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_EDU_ESTB_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION2)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_EDU_ESTB_INFO'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_EDU_ESTB_INFO'
, LEI_INFORMATION4
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_EDU_ESTB_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION5)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_EDU_ESTB_INFO'
, LEI_INFORMATION6
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_MAILING_ADDRESS_INFO'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_MAILING_ADDRESS_INFO'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_MAILING_ADDRESS_INFO'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_PENSERV_LOCATION_INFO'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'PQP_GB_PENSERV_LOCATION_INFO'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'RU_POSTAL_ADDRESS'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEI_INFORMATION1)
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'RU_POSTAL_ADDRESS'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'RU_POSTAL_ADDRESS'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'RU_POSTAL_ADDRESS'
, LEI_INFORMATION5
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'RU_POSTAL_ADDRESS'
, LEI_INFORMATION7
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'RU_POSTAL_ADDRESS'
, LEI_INFORMATION8
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'SE_ALECTA_DETAILS'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'US_LOC_REP_PREFERENCES'
, LEI_INFORMATION1
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ZA_SARS_ADDRESS'
, LEI_INFORMATION2
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ZA_SARS_ADDRESS'
, LEI_INFORMATION3
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ZA_SARS_ADDRESS'
, LEI_INFORMATION4
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'ZA_SARS_ADDRESS'
, LEI_INFORMATION5
, NULL))
, (DECODE (LEI_INFORMATION_CATEGORY
, 'CLM_OFFICE_CODE'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION10
, 'DE_LOCATION_INFO'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1
, 'DK_LOCATION_INFO'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1
, 'EEO-1 ARCHIVE INFORMATION'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION10 || '.' || LEI_INFORMATION11 || '.' || LEI_INFORMATION12 || '.' || LEI_INFORMATION13 || '.' || LEI_INFORMATION14 || '.' || LEI_INFORMATION15 || '.' || LEI_INFORMATION16 || '.' || LEI_INFORMATION17
, 'EEO-1 SPECIFIC INFORMATION'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8
, 'ESTABLISHMENT INFORMATION'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION10
, 'GHR_US_LOC_INFORMATION'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION3
, 'HR_SELF_SERVICE_LOC_PREFERENCE'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION13
, 'HU_MAILING_ADDRESS'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION10
, 'MULTI WORK SITE INFORMATION'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7
, 'NL_POSTAL_ADDRESS'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION13 || '.' || LEI_INFORMATION14 || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION10 || '.' || LEI_INFORMATION11 || '.' || LEI_INFORMATION12
, 'NM SQWL UNIT NUMBER'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1
, 'PER_GEO_HIER_NODE_MAP'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1
, 'PL_CORRESPONDENCE_ADDRESS'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9 || '.' || LEI_INFORMATION10 || '.' || LEI_INFORMATION11 || '.' || LEI_INFORMATION12 || '.' || LEI_INFORMATION13 || '.' || LEI_INFORMATION14 || '.' || LEI_INFORMATION15 || '.' || LEI_INFORMATION16 || '.' || LEI_INFORMATION17
, 'PQP_GB_EDU_ESTB_INFO'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6
, 'PQP_GB_MAILING_ADDRESS_INFO'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8 || '.' || LEI_INFORMATION9
, 'PQP_GB_PENSERV_LOCATION_INFO'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2
, 'RU_POSTAL_ADDRESS'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8
, 'SE_ALECTA_DETAILS'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1
, 'US_LOC_REP_PREFERENCES'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1
, 'VETS-100 SPECIFIC INFORMATION'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2
, 'ZA_SARS_ADDRESS'
, LEI_INFORMATION_CATEGORY || '.' || LEI_INFORMATION1 || '.' || LEI_INFORMATION2 || '.' || LEI_INFORMATION3 || '.' || LEI_INFORMATION4 || '.' || LEI_INFORMATION5 || '.' || LEI_INFORMATION6 || '.' || LEI_INFORMATION7 || '.' || LEI_INFORMATION8
, NULL))
FROM HR_LOCATION_EXTRA_INFO