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_CONTACT_EXTRA_INFO_F_DFV

Source

View Text - Preformatted


SELECT ROWID, CEI_INFORMATION_CATEGORY, (DECODE (CEI_INFORMATION_CATEGORY, 'IN_NOMINATION_DETAILS', CEI_INFORMATION3, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'IN_NOMINATION_DETAILS', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION2), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'IN_NOMINATION_DETAILS', CEI_INFORMATION4, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', TO_DATE(CEI_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), 'JP_HI_DEPENDENT', TO_DATE(CEI_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION4, 'JP_HI_DEPENDENT', CEI_INFORMATION2, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY', CEI_INFORMATION1, 'JP_ITAX_DEPENDENT_ON_OTHER_EMP', CEI_INFORMATION1, 'JP_ITAX_DEPENDENT', CEI_INFORMATION2, 'JP_HI_SPOUSE', CEI_INFORMATION6, 'JP_HI_DEPENDENT', CEI_INFORMATION3, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION7, 'JP_HI_DEPENDENT', CEI_INFORMATION4, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION8, 'JP_HI_DEPENDENT', CEI_INFORMATION5, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', TO_DATE(CEI_INFORMATION10, 'YYYY/MM/DD HH24:MI:SS'), 'JP_HI_DEPENDENT', TO_DATE(CEI_INFORMATION6, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION11, 'JP_HI_DEPENDENT', CEI_INFORMATION7, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION1, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION2, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION5, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', TO_DATE(CEI_INFORMATION13, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION14, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION15, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION9, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION12, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', TO_DATE(CEI_INFORMATION16, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION17, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION18, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION19, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', TO_DATE(CEI_INFORMATION20, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION21, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', CEI_INFORMATION22, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_HI_SPOUSE', TO_DATE(CEI_INFORMATION23, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_ITAX_DEPENDENT', CEI_INFORMATION8, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_ITAX_DEPENDENT', CEI_INFORMATION1, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY', CEI_INFORMATION4, 'JP_ITAX_DEPENDENT', CEI_INFORMATION3, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY', TO_DATE(CEI_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), 'JP_ITAX_DEPENDENT_ON_OTHER_EMP', TO_DATE(CEI_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), 'JP_ITAX_DEPENDENT', TO_DATE(CEI_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY', CEI_INFORMATION6, 'JP_ITAX_DEPENDENT_ON_OTHER_EMP', CEI_INFORMATION3, 'JP_ITAX_DEPENDENT', CEI_INFORMATION5, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_ITAX_DEPENDENT', CEI_INFORMATION6, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_ITAX_DEPENDENT', CEI_INFORMATION7, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_ITAX_DEPENDENT_ON_OTHER_EMP', CEI_INFORMATION5, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY', CEI_INFORMATION2, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY', CEI_INFORMATION3, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION1), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION2), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION10), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION11), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION3), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION4), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION5), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION6), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION7), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION8), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION9), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION16), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION17), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION14), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION15), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION12), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', CEI_INFORMATION13, NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION18), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION19), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION20), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION21), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION22), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION23), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'KR_DPNT_EXPENSE_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION24), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'NO_CMS_DIS_DATE', TO_DATE(CEI_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CEI_INFORMATION_CATEGORY, 'NO_CMS_DIS_DATE', TO_DATE(CEI_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)),  
 (DECODE (CEI_INFORMATION_CATEGORY,  
      'IN_NOMINATION_DETAILS', CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION4,  
      'JP_HI_DEPENDENT', CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION4 || '.' || CEI_INFORMATION5 || '.' || CEI_INFORMATION6 || '.' || CEI_INFORMATION7,  
      'JP_HI_SPOUSE', CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION4 || '.' || CEI_INFORMATION5 || '.' || CEI_INFORMATION13 || '.' || CEI_INFORMATION14 || '.' || CEI_INFORMATION15 || '.' || CEI_INFORMATION6 || '.' || CEI_INFORMATION7 || '.' || CEI_INFORMATION8 || '.' || CEI_INFORMATION9 || '.' || CEI_INFORMATION10 || '.' || CEI_INFORMATION11 || '.' || CEI_INFORMATION12 || '.' || CEI_INFORMATION16 || '.' || CEI_INFORMATION17 || '.' || CEI_INFORMATION18 || '.' || CEI_INFORMATION19 || '.' || CEI_INFORMATION20 || '.' || CEI_INFORMATION21 || '.' || CEI_INFORMATION22 || '.' || CEI_INFORMATION23,  
      'JP_ITAX_DEPENDENT', CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION8 || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION4 || '.' || CEI_INFORMATION5 || '.' || CEI_INFORMATION6 || '.' || CEI_INFORMATION7,  
      'JP_ITAX_DEPENDENT_ON_OTHER_EMP', CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION5,  
      'JP_ITAX_DEPENDENT_ON_OTHER_PAY', CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION4 || '.' || CEI_INFORMATION5 || '.' || CEI_INFORMATION6,  
      'KR_DPNT_EXPENSE_INFO', CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION10 || '.' || CEI_INFORMATION11 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION4 || '.' || CEI_INFORMATION5 || '.' || CEI_INFORMATION6 || '.' || CEI_INFORMATION7 || '.' || CEI_INFORMATION8 || '.' || CEI_INFORMATION9 || '.' || CEI_INFORMATION16 || '.' || CEI_INFORMATION17 || '.' || CEI_INFORMATION14 || '.' || CEI_INFORMATION15 || '.' || CEI_INFORMATION12 || '.' || CEI_INFORMATION13 || '.' || CEI_INFORMATION18 || '.' || CEI_INFORMATION19 || '.' || CEI_INFORMATION20 || '.' || CEI_INFORMATION21 || '.' || CEI_INFORMATION22 || '.' || CEI_INFORMATION23 || '.' || CEI_INFORMATION24,  
      'NO_CMS_DIS_DATE', CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2, NULL)) 
 FROM PER_CONTACT_EXTRA_INFO_F

View Text - HTML Formatted

SELECT ROWID
, CEI_INFORMATION_CATEGORY
, (DECODE (CEI_INFORMATION_CATEGORY
, 'IN_NOMINATION_DETAILS'
, CEI_INFORMATION3
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'IN_NOMINATION_DETAILS'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION2)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'IN_NOMINATION_DETAILS'
, CEI_INFORMATION4
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, TO_DATE(CEI_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, 'JP_HI_DEPENDENT'
, TO_DATE(CEI_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION4
, 'JP_HI_DEPENDENT'
, CEI_INFORMATION2
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY'
, CEI_INFORMATION1
, 'JP_ITAX_DEPENDENT_ON_OTHER_EMP'
, CEI_INFORMATION1
, 'JP_ITAX_DEPENDENT'
, CEI_INFORMATION2
, 'JP_HI_SPOUSE'
, CEI_INFORMATION6
, 'JP_HI_DEPENDENT'
, CEI_INFORMATION3
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION7
, 'JP_HI_DEPENDENT'
, CEI_INFORMATION4
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION8
, 'JP_HI_DEPENDENT'
, CEI_INFORMATION5
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, TO_DATE(CEI_INFORMATION10
, 'YYYY/MM/DD HH24:MI:SS')
, 'JP_HI_DEPENDENT'
, TO_DATE(CEI_INFORMATION6
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION11
, 'JP_HI_DEPENDENT'
, CEI_INFORMATION7
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION1
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION2
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION5
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, TO_DATE(CEI_INFORMATION13
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION14
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION15
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION9
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION12
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, TO_DATE(CEI_INFORMATION16
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION17
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION18
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION19
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, TO_DATE(CEI_INFORMATION20
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION21
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, CEI_INFORMATION22
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_HI_SPOUSE'
, TO_DATE(CEI_INFORMATION23
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_ITAX_DEPENDENT'
, CEI_INFORMATION8
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_ITAX_DEPENDENT'
, CEI_INFORMATION1
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY'
, CEI_INFORMATION4
, 'JP_ITAX_DEPENDENT'
, CEI_INFORMATION3
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY'
, TO_DATE(CEI_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, 'JP_ITAX_DEPENDENT_ON_OTHER_EMP'
, TO_DATE(CEI_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, 'JP_ITAX_DEPENDENT'
, TO_DATE(CEI_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY'
, CEI_INFORMATION6
, 'JP_ITAX_DEPENDENT_ON_OTHER_EMP'
, CEI_INFORMATION3
, 'JP_ITAX_DEPENDENT'
, CEI_INFORMATION5
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_ITAX_DEPENDENT'
, CEI_INFORMATION6
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_ITAX_DEPENDENT'
, CEI_INFORMATION7
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_ITAX_DEPENDENT_ON_OTHER_EMP'
, CEI_INFORMATION5
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY'
, CEI_INFORMATION2
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY'
, CEI_INFORMATION3
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION1)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION2)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION10)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION11)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION3)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION4)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION5)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION6)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION7)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION8)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION9)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION16)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION17)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION14)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION15)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION12)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, CEI_INFORMATION13
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION18)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION19)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION20)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION21)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION22)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION23)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'KR_DPNT_EXPENSE_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CEI_INFORMATION24)
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'NO_CMS_DIS_DATE'
, TO_DATE(CEI_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'NO_CMS_DIS_DATE'
, TO_DATE(CEI_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CEI_INFORMATION_CATEGORY
, 'IN_NOMINATION_DETAILS'
, CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION4
, 'JP_HI_DEPENDENT'
, CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION4 || '.' || CEI_INFORMATION5 || '.' || CEI_INFORMATION6 || '.' || CEI_INFORMATION7
, 'JP_HI_SPOUSE'
, CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION4 || '.' || CEI_INFORMATION5 || '.' || CEI_INFORMATION13 || '.' || CEI_INFORMATION14 || '.' || CEI_INFORMATION15 || '.' || CEI_INFORMATION6 || '.' || CEI_INFORMATION7 || '.' || CEI_INFORMATION8 || '.' || CEI_INFORMATION9 || '.' || CEI_INFORMATION10 || '.' || CEI_INFORMATION11 || '.' || CEI_INFORMATION12 || '.' || CEI_INFORMATION16 || '.' || CEI_INFORMATION17 || '.' || CEI_INFORMATION18 || '.' || CEI_INFORMATION19 || '.' || CEI_INFORMATION20 || '.' || CEI_INFORMATION21 || '.' || CEI_INFORMATION22 || '.' || CEI_INFORMATION23
, 'JP_ITAX_DEPENDENT'
, CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION8 || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION4 || '.' || CEI_INFORMATION5 || '.' || CEI_INFORMATION6 || '.' || CEI_INFORMATION7
, 'JP_ITAX_DEPENDENT_ON_OTHER_EMP'
, CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION5
, 'JP_ITAX_DEPENDENT_ON_OTHER_PAY'
, CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION4 || '.' || CEI_INFORMATION5 || '.' || CEI_INFORMATION6
, 'KR_DPNT_EXPENSE_INFO'
, CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2 || '.' || CEI_INFORMATION10 || '.' || CEI_INFORMATION11 || '.' || CEI_INFORMATION3 || '.' || CEI_INFORMATION4 || '.' || CEI_INFORMATION5 || '.' || CEI_INFORMATION6 || '.' || CEI_INFORMATION7 || '.' || CEI_INFORMATION8 || '.' || CEI_INFORMATION9 || '.' || CEI_INFORMATION16 || '.' || CEI_INFORMATION17 || '.' || CEI_INFORMATION14 || '.' || CEI_INFORMATION15 || '.' || CEI_INFORMATION12 || '.' || CEI_INFORMATION13 || '.' || CEI_INFORMATION18 || '.' || CEI_INFORMATION19 || '.' || CEI_INFORMATION20 || '.' || CEI_INFORMATION21 || '.' || CEI_INFORMATION22 || '.' || CEI_INFORMATION23 || '.' || CEI_INFORMATION24
, 'NO_CMS_DIS_DATE'
, CEI_INFORMATION_CATEGORY || '.' || CEI_INFORMATION1 || '.' || CEI_INFORMATION2
, NULL))
FROM PER_CONTACT_EXTRA_INFO_F