VIEW: APPS.PER_CONTRACTS_F_DFV

Source

View Text - Preformatted

SELECT ROWID, CTR_INFORMATION_CATEGORY, (DECODE (CTR_INFORMATION_CATEGORY, 'SA', CTR_INFORMATION1, 'KW', CTR_INFORMATION1, 'AE', CTR_INFORMATION1, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'SA', TO_DATE(CTR_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), 'KW', TO_DATE(CTR_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), 'AE', TO_DATE(CTR_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', CTR_INFORMATION2, 'BE', CTR_INFORMATION1, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'BE', TO_DATE(CTR_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'BE', TO_DATE(CTR_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'BE', TO_DATE(CTR_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'BE', TO_DATE(CTR_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'BE', FND_NUMBER.CANONICAL_TO_NUMBER(CTR_INFORMATION6), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'BE', CTR_INFORMATION7, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'BE', CTR_INFORMATION8, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', TO_DATE(CTR_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION2, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION3, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', TO_DATE(CTR_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', TO_DATE(CTR_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION6, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION7, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION19, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION20, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION8, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION9, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION10, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION11, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', TO_DATE(CTR_INFORMATION12, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', TO_DATE(CTR_INFORMATION13, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', TO_DATE(CTR_INFORMATION14, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION15, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', TO_DATE(CTR_INFORMATION16, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION17, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'CN', CTR_INFORMATION18, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION1, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION2, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION3, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION4, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION5, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION6, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION7, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION8, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION9, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION10, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION11, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION12, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', FND_NUMBER.CANONICAL_TO_NUMBER(CTR_INFORMATION13), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION14, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION15, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION16, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION17, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION18, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION19, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'DE_PQH', CTR_INFORMATION20, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'ES', CTR_INFORMATION1, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'ES', CTR_INFORMATION2, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'ES', CTR_INFORMATION3, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', TO_DATE(CTR_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), 'ES', TO_DATE(CTR_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', CTR_INFORMATION5, 'ES', CTR_INFORMATION5, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'ES', CTR_INFORMATION6, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', CTR_INFORMATION1, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', CTR_INFORMATION4, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(CTR_INFORMATION6), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', CTR_INFORMATION7, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', TO_DATE(CTR_INFORMATION8, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(CTR_INFORMATION9), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', CTR_INFORMATION10, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(CTR_INFORMATION11), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', CTR_INFORMATION12, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'FR', CTR_INFORMATION13, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'HU', TO_DATE(CTR_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'NO', TO_DATE(CTR_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'RO', CTR_INFORMATION1, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'RO', CTR_INFORMATION2, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'RO', CTR_INFORMATION3, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'RO', CTR_INFORMATION4, NULL)), (DECODE (CTR_INFORMATION_CATEGORY, 'RO', CTR_INFORMATION5, NULL)),  
 (DECODE (CTR_INFORMATION_CATEGORY,  
      'AE', CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2,  
      'BE', CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5 || '.' || CTR_INFORMATION6 || '.' || CTR_INFORMATION7 || '.' || CTR_INFORMATION8,  
      'CN', CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5 || '.' || CTR_INFORMATION6 || '.' || CTR_INFORMATION7 || '.' || CTR_INFORMATION19 || '.' || CTR_INFORMATION20 || '.' || CTR_INFORMATION8 || '.' || CTR_INFORMATION9 || '.' || CTR_INFORMATION10 || '.' || CTR_INFORMATION11 || '.' || CTR_INFORMATION12 || '.' || CTR_INFORMATION13 || '.' || CTR_INFORMATION14 || '.' || CTR_INFORMATION15 || '.' || CTR_INFORMATION16 || '.' || CTR_INFORMATION17 || '.' || CTR_INFORMATION18,  
      'DE_PQH', CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5 || '.' || CTR_INFORMATION6 || '.' || CTR_INFORMATION7 || '.' || CTR_INFORMATION8 || '.' || CTR_INFORMATION9 || '.' || CTR_INFORMATION10 || '.' || CTR_INFORMATION11 || '.' || CTR_INFORMATION12 || '.' || CTR_INFORMATION13 || '.' || CTR_INFORMATION14 || '.' || CTR_INFORMATION15 || '.' || CTR_INFORMATION16 || '.' || CTR_INFORMATION17 || '.' || CTR_INFORMATION18 || '.' || CTR_INFORMATION19 || '.' || CTR_INFORMATION20,  
      'ES', CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5 || '.' || CTR_INFORMATION6,  
      'FR', CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5 || '.' || CTR_INFORMATION6 || '.' || CTR_INFORMATION7 || '.' || CTR_INFORMATION8 || '.' || CTR_INFORMATION9 || '.' || CTR_INFORMATION10 || '.' || CTR_INFORMATION11 || '.' || CTR_INFORMATION12 || '.' || CTR_INFORMATION13,  
      'HU', CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1,  
      'KW', CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2,  
      'NO', CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1,  
      'RO', CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5,  
      'SA', CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2, NULL)) 
 FROM PER_CONTRACTS_F

View Text - HTML Formatted

SELECT ROWID
, CTR_INFORMATION_CATEGORY
, (DECODE (CTR_INFORMATION_CATEGORY
, 'SA'
, CTR_INFORMATION1
, 'KW'
, CTR_INFORMATION1
, 'AE'
, CTR_INFORMATION1
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'SA'
, TO_DATE(CTR_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, 'KW'
, TO_DATE(CTR_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, 'AE'
, TO_DATE(CTR_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, CTR_INFORMATION2
, 'BE'
, CTR_INFORMATION1
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'BE'
, TO_DATE(CTR_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'BE'
, TO_DATE(CTR_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'BE'
, TO_DATE(CTR_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'BE'
, TO_DATE(CTR_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'BE'
, FND_NUMBER.CANONICAL_TO_NUMBER(CTR_INFORMATION6)
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'BE'
, CTR_INFORMATION7
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'BE'
, CTR_INFORMATION8
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, TO_DATE(CTR_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION2
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION3
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, TO_DATE(CTR_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, TO_DATE(CTR_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION6
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION7
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION19
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION20
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION8
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION9
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION10
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION11
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, TO_DATE(CTR_INFORMATION12
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, TO_DATE(CTR_INFORMATION13
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, TO_DATE(CTR_INFORMATION14
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION15
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, TO_DATE(CTR_INFORMATION16
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION17
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'CN'
, CTR_INFORMATION18
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION1
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION2
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION3
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION4
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION5
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION6
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION7
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION8
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION9
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION10
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION11
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION12
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, FND_NUMBER.CANONICAL_TO_NUMBER(CTR_INFORMATION13)
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION14
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION15
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION16
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION17
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION18
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION19
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'DE_PQH'
, CTR_INFORMATION20
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'ES'
, CTR_INFORMATION1
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'ES'
, CTR_INFORMATION2
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'ES'
, CTR_INFORMATION3
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(CTR_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, 'ES'
, TO_DATE(CTR_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, CTR_INFORMATION5
, 'ES'
, CTR_INFORMATION5
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'ES'
, CTR_INFORMATION6
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, CTR_INFORMATION1
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, CTR_INFORMATION4
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(CTR_INFORMATION6)
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, CTR_INFORMATION7
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(CTR_INFORMATION8
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(CTR_INFORMATION9)
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, CTR_INFORMATION10
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(CTR_INFORMATION11)
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, CTR_INFORMATION12
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'FR'
, CTR_INFORMATION13
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'HU'
, TO_DATE(CTR_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'NO'
, TO_DATE(CTR_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'RO'
, CTR_INFORMATION1
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'RO'
, CTR_INFORMATION2
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'RO'
, CTR_INFORMATION3
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'RO'
, CTR_INFORMATION4
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'RO'
, CTR_INFORMATION5
, NULL))
, (DECODE (CTR_INFORMATION_CATEGORY
, 'AE'
, CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2
, 'BE'
, CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5 || '.' || CTR_INFORMATION6 || '.' || CTR_INFORMATION7 || '.' || CTR_INFORMATION8
, 'CN'
, CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5 || '.' || CTR_INFORMATION6 || '.' || CTR_INFORMATION7 || '.' || CTR_INFORMATION19 || '.' || CTR_INFORMATION20 || '.' || CTR_INFORMATION8 || '.' || CTR_INFORMATION9 || '.' || CTR_INFORMATION10 || '.' || CTR_INFORMATION11 || '.' || CTR_INFORMATION12 || '.' || CTR_INFORMATION13 || '.' || CTR_INFORMATION14 || '.' || CTR_INFORMATION15 || '.' || CTR_INFORMATION16 || '.' || CTR_INFORMATION17 || '.' || CTR_INFORMATION18
, 'DE_PQH'
, CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5 || '.' || CTR_INFORMATION6 || '.' || CTR_INFORMATION7 || '.' || CTR_INFORMATION8 || '.' || CTR_INFORMATION9 || '.' || CTR_INFORMATION10 || '.' || CTR_INFORMATION11 || '.' || CTR_INFORMATION12 || '.' || CTR_INFORMATION13 || '.' || CTR_INFORMATION14 || '.' || CTR_INFORMATION15 || '.' || CTR_INFORMATION16 || '.' || CTR_INFORMATION17 || '.' || CTR_INFORMATION18 || '.' || CTR_INFORMATION19 || '.' || CTR_INFORMATION20
, 'ES'
, CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5 || '.' || CTR_INFORMATION6
, 'FR'
, CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5 || '.' || CTR_INFORMATION6 || '.' || CTR_INFORMATION7 || '.' || CTR_INFORMATION8 || '.' || CTR_INFORMATION9 || '.' || CTR_INFORMATION10 || '.' || CTR_INFORMATION11 || '.' || CTR_INFORMATION12 || '.' || CTR_INFORMATION13
, 'HU'
, CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1
, 'KW'
, CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2
, 'NO'
, CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1
, 'RO'
, CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2 || '.' || CTR_INFORMATION3 || '.' || CTR_INFORMATION4 || '.' || CTR_INFORMATION5
, 'SA'
, CTR_INFORMATION_CATEGORY || '.' || CTR_INFORMATION1 || '.' || CTR_INFORMATION2
, NULL))
FROM PER_CONTRACTS_F