VIEW: APPS.PER_WORK_INCIDENTS1_DFV

Source

View Text - Preformatted

SELECT ROWID, INC_INFORMATION_CATEGORY, (DECODE (INC_INFORMATION_CATEGORY, 'DE', FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION1), NULL)), INC_INFORMATION2, (DECODE (INC_INFORMATION_CATEGORY, 'DE', TO_DATE(INC_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), INC_INFORMATION4, INC_INFORMATION5, INC_INFORMATION6, INC_INFORMATION7, INC_INFORMATION8, (DECODE (INC_INFORMATION_CATEGORY, 'DE', TO_DATE(INC_INFORMATION9, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'DE', TO_DATE(INC_INFORMATION10, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'DE', TO_DATE(INC_INFORMATION11, 'YYYY/MM/DD HH24:MI:SS'), NULL)), INC_INFORMATION12, INC_INFORMATION14, (DECODE (INC_INFORMATION_CATEGORY, 'DE', TO_DATE(INC_INFORMATION15, 'HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'DE', TO_DATE(INC_INFORMATION16, 'HH24:MI:SS'), NULL)), INC_INFORMATION17, INC_INFORMATION18, (DECODE (INC_INFORMATION_CATEGORY, 'DE', TO_DATE(INC_INFORMATION19, 'YYYY/MM/DD HH24:MI:SS'), NULL)), INC_INFORMATION20, INC_INFORMATION21, INC_INFORMATION1, INC_INFORMATION2, INC_INFORMATION3, INC_INFORMATION4, INC_INFORMATION5, INC_INFORMATION6, INC_INFORMATION7, INC_INFORMATION8, INC_INFORMATION9, INC_INFORMATION10, INC_INFORMATION11, (DECODE (INC_INFORMATION_CATEGORY, 'DK', TO_DATE(INC_INFORMATION12, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'DK', FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION13), NULL)), INC_INFORMATION14, INC_INFORMATION1, (DECODE (INC_INFORMATION_CATEGORY, 'FR', TO_DATE(INC_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'FR', TO_DATE(INC_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), INC_INFORMATION4, INC_INFORMATION5, INC_INFORMATION6, INC_INFORMATION7, INC_INFORMATION8, INC_INFORMATION9, INC_INFORMATION10, INC_INFORMATION1, INC_INFORMATION2, (DECODE (INC_INFORMATION_CATEGORY, 'KW', FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION1), NULL)), INC_INFORMATION2, INC_INFORMATION1, (DECODE (INC_INFORMATION_CATEGORY, 'NO', TO_DATE(INC_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'NO', TO_DATE(INC_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), INC_INFORMATION2, INC_INFORMATION3, INC_INFORMATION4, INC_INFORMATION5, INC_INFORMATION6, INC_INFORMATION7, INC_INFORMATION8, INC_INFORMATION9, INC_INFORMATION10, INC_INFORMATION11, INC_INFORMATION12, INC_INFORMATION13, (DECODE (INC_INFORMATION_CATEGORY, 'SA', TO_DATE(INC_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), INC_INFORMATION2, (DECODE (INC_INFORMATION_CATEGORY, 'SA', TO_DATE(INC_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'SA', TO_DATE(INC_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'SA', TO_DATE(INC_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'SA', TO_DATE(INC_INFORMATION6, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'SA', TO_DATE(INC_INFORMATION7, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'SA', FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION8), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'SA', FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION9), NULL)), INC_INFORMATION10, (DECODE (INC_INFORMATION_CATEGORY, 'SA', FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION11), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'SA', TO_DATE(INC_INFORMATION12, 'YYYY/MM/DD HH24:MI:SS'), NULL)), INC_INFORMATION1, (DECODE (INC_INFORMATION_CATEGORY, 'SE', TO_DATE(INC_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INC_INFORMATION_CATEGORY, 'SE', TO_DATE(INC_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), INC_INFORMATION4, INC_INFORMATION5, INC_INFORMATION6, INC_INFORMATION7, INC_INFORMATION8, INC_INFORMATION9, INC_INFORMATION10, INC_INFORMATION11, INC_INFORMATION12, INC_INFORMATION13, INC_INFORMATION14, INC_INFORMATION15, INC_INFORMATION16, INC_INFORMATION17, (DECODE (INC_INFORMATION_CATEGORY, 'SE', FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION18), NULL)), INC_INFORMATION19, INC_INFORMATION20, INC_INFORMATION1,  
 (DECODE (INC_INFORMATION_CATEGORY,  
      'DE', INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10 || '.' || INC_INFORMATION11 || '.' || INC_INFORMATION12 || '.' || INC_INFORMATION14 || '.' || INC_INFORMATION15 || '.' || INC_INFORMATION16 || '.' || INC_INFORMATION17 || '.' || INC_INFORMATION18 || '.' || INC_INFORMATION19 || '.' || INC_INFORMATION20 || '.' || INC_INFORMATION21,  
      'DK', INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10 || '.' || INC_INFORMATION11 || '.' || INC_INFORMATION12 || '.' || INC_INFORMATION13 || '.' || INC_INFORMATION14,  
      'FR', INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10,  
      'IN', INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2,  
      'KW', INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2,  
      'MX', INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1,  
      'NO', INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2,  
      'RU', INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10 || '.' || INC_INFORMATION11 || '.' || INC_INFORMATION12 || '.' || INC_INFORMATION13,  
      'SA', INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10 || '.' || INC_INFORMATION11 || '.' || INC_INFORMATION12,  
      'SE', INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10 || '.' || INC_INFORMATION11 || '.' || INC_INFORMATION12 || '.' || INC_INFORMATION13 || '.' || INC_INFORMATION14 || '.' || INC_INFORMATION15 || '.' || INC_INFORMATION16 || '.' || INC_INFORMATION17 || '.' || INC_INFORMATION18 || '.' || INC_INFORMATION19 || '.' || INC_INFORMATION20,  
      'US', INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1, NULL)) 
 FROM PER_WORK_INCIDENTS

View Text - HTML Formatted

SELECT ROWID
, INC_INFORMATION_CATEGORY
, (DECODE (INC_INFORMATION_CATEGORY
, 'DE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION1)
, NULL))
, INC_INFORMATION2
, (DECODE (INC_INFORMATION_CATEGORY
, 'DE'
, TO_DATE(INC_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, INC_INFORMATION4
, INC_INFORMATION5
, INC_INFORMATION6
, INC_INFORMATION7
, INC_INFORMATION8
, (DECODE (INC_INFORMATION_CATEGORY
, 'DE'
, TO_DATE(INC_INFORMATION9
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'DE'
, TO_DATE(INC_INFORMATION10
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'DE'
, TO_DATE(INC_INFORMATION11
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, INC_INFORMATION12
, INC_INFORMATION14
, (DECODE (INC_INFORMATION_CATEGORY
, 'DE'
, TO_DATE(INC_INFORMATION15
, 'HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'DE'
, TO_DATE(INC_INFORMATION16
, 'HH24:MI:SS')
, NULL))
, INC_INFORMATION17
, INC_INFORMATION18
, (DECODE (INC_INFORMATION_CATEGORY
, 'DE'
, TO_DATE(INC_INFORMATION19
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, INC_INFORMATION20
, INC_INFORMATION21
, INC_INFORMATION1
, INC_INFORMATION2
, INC_INFORMATION3
, INC_INFORMATION4
, INC_INFORMATION5
, INC_INFORMATION6
, INC_INFORMATION7
, INC_INFORMATION8
, INC_INFORMATION9
, INC_INFORMATION10
, INC_INFORMATION11
, (DECODE (INC_INFORMATION_CATEGORY
, 'DK'
, TO_DATE(INC_INFORMATION12
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'DK'
, FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION13)
, NULL))
, INC_INFORMATION14
, INC_INFORMATION1
, (DECODE (INC_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(INC_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(INC_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, INC_INFORMATION4
, INC_INFORMATION5
, INC_INFORMATION6
, INC_INFORMATION7
, INC_INFORMATION8
, INC_INFORMATION9
, INC_INFORMATION10
, INC_INFORMATION1
, INC_INFORMATION2
, (DECODE (INC_INFORMATION_CATEGORY
, 'KW'
, FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION1)
, NULL))
, INC_INFORMATION2
, INC_INFORMATION1
, (DECODE (INC_INFORMATION_CATEGORY
, 'NO'
, TO_DATE(INC_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'NO'
, TO_DATE(INC_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, INC_INFORMATION2
, INC_INFORMATION3
, INC_INFORMATION4
, INC_INFORMATION5
, INC_INFORMATION6
, INC_INFORMATION7
, INC_INFORMATION8
, INC_INFORMATION9
, INC_INFORMATION10
, INC_INFORMATION11
, INC_INFORMATION12
, INC_INFORMATION13
, (DECODE (INC_INFORMATION_CATEGORY
, 'SA'
, TO_DATE(INC_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, INC_INFORMATION2
, (DECODE (INC_INFORMATION_CATEGORY
, 'SA'
, TO_DATE(INC_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'SA'
, TO_DATE(INC_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'SA'
, TO_DATE(INC_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'SA'
, TO_DATE(INC_INFORMATION6
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'SA'
, TO_DATE(INC_INFORMATION7
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'SA'
, FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION8)
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'SA'
, FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION9)
, NULL))
, INC_INFORMATION10
, (DECODE (INC_INFORMATION_CATEGORY
, 'SA'
, FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION11)
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'SA'
, TO_DATE(INC_INFORMATION12
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, INC_INFORMATION1
, (DECODE (INC_INFORMATION_CATEGORY
, 'SE'
, TO_DATE(INC_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INC_INFORMATION_CATEGORY
, 'SE'
, TO_DATE(INC_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, INC_INFORMATION4
, INC_INFORMATION5
, INC_INFORMATION6
, INC_INFORMATION7
, INC_INFORMATION8
, INC_INFORMATION9
, INC_INFORMATION10
, INC_INFORMATION11
, INC_INFORMATION12
, INC_INFORMATION13
, INC_INFORMATION14
, INC_INFORMATION15
, INC_INFORMATION16
, INC_INFORMATION17
, (DECODE (INC_INFORMATION_CATEGORY
, 'SE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INC_INFORMATION18)
, NULL))
, INC_INFORMATION19
, INC_INFORMATION20
, INC_INFORMATION1
, (DECODE (INC_INFORMATION_CATEGORY
, 'DE'
, INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10 || '.' || INC_INFORMATION11 || '.' || INC_INFORMATION12 || '.' || INC_INFORMATION14 || '.' || INC_INFORMATION15 || '.' || INC_INFORMATION16 || '.' || INC_INFORMATION17 || '.' || INC_INFORMATION18 || '.' || INC_INFORMATION19 || '.' || INC_INFORMATION20 || '.' || INC_INFORMATION21
, 'DK'
, INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10 || '.' || INC_INFORMATION11 || '.' || INC_INFORMATION12 || '.' || INC_INFORMATION13 || '.' || INC_INFORMATION14
, 'FR'
, INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10
, 'IN'
, INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2
, 'KW'
, INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2
, 'MX'
, INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1
, 'NO'
, INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2
, 'RU'
, INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10 || '.' || INC_INFORMATION11 || '.' || INC_INFORMATION12 || '.' || INC_INFORMATION13
, 'SA'
, INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10 || '.' || INC_INFORMATION11 || '.' || INC_INFORMATION12
, 'SE'
, INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1 || '.' || INC_INFORMATION2 || '.' || INC_INFORMATION3 || '.' || INC_INFORMATION4 || '.' || INC_INFORMATION5 || '.' || INC_INFORMATION6 || '.' || INC_INFORMATION7 || '.' || INC_INFORMATION8 || '.' || INC_INFORMATION9 || '.' || INC_INFORMATION10 || '.' || INC_INFORMATION11 || '.' || INC_INFORMATION12 || '.' || INC_INFORMATION13 || '.' || INC_INFORMATION14 || '.' || INC_INFORMATION15 || '.' || INC_INFORMATION16 || '.' || INC_INFORMATION17 || '.' || INC_INFORMATION18 || '.' || INC_INFORMATION19 || '.' || INC_INFORMATION20
, 'US'
, INC_INFORMATION_CATEGORY || '.' || INC_INFORMATION1
, NULL))
FROM PER_WORK_INCIDENTS