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

Source

View Text - Preformatted


SELECT ROWID, PRL_INFORMATION_CATEGORY, PRL_INFORMATION20, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION21), FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION22), (DECODE (PRL_INFORMATION_CATEGORY, 'CA', PRL_INFORMATION1, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'CA', PRL_INFORMATION2, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'CA', PRL_INFORMATION3, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'CA', PRL_INFORMATION4, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION5, 'CA', PRL_INFORMATION5, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION6, 'CA', PRL_INFORMATION6, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION1, 'KR', PRL_INFORMATION8, 'CA', PRL_INFORMATION7, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'DK', PRL_INFORMATION1, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FI', PRL_INFORMATION1, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', PRL_INFORMATION1, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION2), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION3), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION4), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', PRL_INFORMATION5, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', PRL_INFORMATION6, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION7), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION8), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION9), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION10), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', PRL_INFORMATION11, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', PRL_INFORMATION12, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION13), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION14), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION15), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', PRL_INFORMATION16, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', TO_DATE(PRL_INFORMATION17, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', PRL_INFORMATION18, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'FR', PRL_INFORMATION19, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'IN', PRL_INFORMATION1, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'JP', PRL_INFORMATION1, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'JP', PRL_INFORMATION2, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'JP', PRL_INFORMATION4, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'JP', PRL_INFORMATION5, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'JP', PRL_INFORMATION3, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'KR', PRL_INFORMATION1, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'KR', PRL_INFORMATION7, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'KR', PRL_INFORMATION9, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'KR', PRL_INFORMATION10, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'KR', PRL_INFORMATION2, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'KR', PRL_INFORMATION3, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'KR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION4), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'KR', PRL_INFORMATION5, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'KR', PRL_INFORMATION6, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'MX', PRL_INFORMATION1, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'MX', PRL_INFORMATION2, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'MX', PRL_INFORMATION3, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'MX', PRL_INFORMATION10, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'MX', PRL_INFORMATION4, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'MX', PRL_INFORMATION5, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'MX', PRL_INFORMATION6, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'MX', PRL_INFORMATION7, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'MX', PRL_INFORMATION8, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'MX', PRL_INFORMATION9, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'NL', PRL_INFORMATION1, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'SE', PRL_INFORMATION1, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'SE', PRL_INFORMATION2, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'SE', PRL_INFORMATION3, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION2, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION3, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION4, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION7, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION14, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION8, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION9), NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION10, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION11, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION12, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION13, NULL)), (DECODE (PRL_INFORMATION_CATEGORY, 'US', PRL_INFORMATION15, NULL)),  
 PRL_INFORMATION20 || '.' || PRL_INFORMATION21 || '.' || PRL_INFORMATION22 || '.' || (DECODE (PRL_INFORMATION_CATEGORY,  
      'CA', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION6 || '.' || PRL_INFORMATION7,  
      'DK', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1,  
      'FI', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1,  
      'FR', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION6 || '.' || PRL_INFORMATION7 || '.' || PRL_INFORMATION8 || '.' || PRL_INFORMATION9 || '.' || PRL_INFORMATION10 || '.' || PRL_INFORMATION11 || '.' || PRL_INFORMATION12 || '.' || PRL_INFORMATION13 || '.' || PRL_INFORMATION14 || '.' || PRL_INFORMATION15 || '.' || PRL_INFORMATION16 || '.' || PRL_INFORMATION17 || '.' || PRL_INFORMATION18 || '.' || PRL_INFORMATION19,  
      'IN', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1,  
      'JP', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION3,  
      'KR', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION7 || '.' || PRL_INFORMATION9 || '.' || PRL_INFORMATION10 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION6 || '.' || PRL_INFORMATION8,  
      'MX', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3 || '.' || PRL_INFORMATION10 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION6 || '.' || PRL_INFORMATION7 || '.' || PRL_INFORMATION8 || '.' || PRL_INFORMATION9,  
      'NL', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1,  
      'SE', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3,  
      'US', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION6 || '.' || PRL_INFORMATION7 || '.' || PRL_INFORMATION14 || '.' || PRL_INFORMATION8 || '.' || PRL_INFORMATION9 || '.' || PRL_INFORMATION10 || '.' || PRL_INFORMATION11 || '.' || PRL_INFORMATION12 || '.' || PRL_INFORMATION13 || '.' || PRL_INFORMATION15, NULL)) 
 FROM PAY_ALL_PAYROLLS_F

View Text - HTML Formatted

SELECT ROWID
, PRL_INFORMATION_CATEGORY
, PRL_INFORMATION20
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION21)
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION22)
, (DECODE (PRL_INFORMATION_CATEGORY
, 'CA'
, PRL_INFORMATION1
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'CA'
, PRL_INFORMATION2
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'CA'
, PRL_INFORMATION3
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'CA'
, PRL_INFORMATION4
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION5
, 'CA'
, PRL_INFORMATION5
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION6
, 'CA'
, PRL_INFORMATION6
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION1
, 'KR'
, PRL_INFORMATION8
, 'CA'
, PRL_INFORMATION7
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'DK'
, PRL_INFORMATION1
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FI'
, PRL_INFORMATION1
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, PRL_INFORMATION1
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION2)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION3)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION4)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, PRL_INFORMATION5
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, PRL_INFORMATION6
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION7)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION8)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION9)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION10)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, PRL_INFORMATION11
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, PRL_INFORMATION12
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION13)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION14)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION15)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, PRL_INFORMATION16
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(PRL_INFORMATION17
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, PRL_INFORMATION18
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, PRL_INFORMATION19
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'IN'
, PRL_INFORMATION1
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'JP'
, PRL_INFORMATION1
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'JP'
, PRL_INFORMATION2
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'JP'
, PRL_INFORMATION4
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'JP'
, PRL_INFORMATION5
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'JP'
, PRL_INFORMATION3
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'KR'
, PRL_INFORMATION1
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'KR'
, PRL_INFORMATION7
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'KR'
, PRL_INFORMATION9
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'KR'
, PRL_INFORMATION10
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'KR'
, PRL_INFORMATION2
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'KR'
, PRL_INFORMATION3
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'KR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION4)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'KR'
, PRL_INFORMATION5
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'KR'
, PRL_INFORMATION6
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'MX'
, PRL_INFORMATION1
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'MX'
, PRL_INFORMATION2
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'MX'
, PRL_INFORMATION3
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'MX'
, PRL_INFORMATION10
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'MX'
, PRL_INFORMATION4
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'MX'
, PRL_INFORMATION5
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'MX'
, PRL_INFORMATION6
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'MX'
, PRL_INFORMATION7
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'MX'
, PRL_INFORMATION8
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'MX'
, PRL_INFORMATION9
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'NL'
, PRL_INFORMATION1
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'SE'
, PRL_INFORMATION1
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'SE'
, PRL_INFORMATION2
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'SE'
, PRL_INFORMATION3
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION2
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION3
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION4
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION7
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION14
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION8
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION9)
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION10
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION11
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION12
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION13
, NULL))
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, PRL_INFORMATION15
, NULL))
, PRL_INFORMATION20 || '.' || PRL_INFORMATION21 || '.' || PRL_INFORMATION22 || '.' || (DECODE (PRL_INFORMATION_CATEGORY
, 'CA'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION6 || '.' || PRL_INFORMATION7
, 'DK'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1
, 'FI'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1
, 'FR'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION6 || '.' || PRL_INFORMATION7 || '.' || PRL_INFORMATION8 || '.' || PRL_INFORMATION9 || '.' || PRL_INFORMATION10 || '.' || PRL_INFORMATION11 || '.' || PRL_INFORMATION12 || '.' || PRL_INFORMATION13 || '.' || PRL_INFORMATION14 || '.' || PRL_INFORMATION15 || '.' || PRL_INFORMATION16 || '.' || PRL_INFORMATION17 || '.' || PRL_INFORMATION18 || '.' || PRL_INFORMATION19
, 'IN'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1
, 'JP'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION3
, 'KR'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION7 || '.' || PRL_INFORMATION9 || '.' || PRL_INFORMATION10 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION6 || '.' || PRL_INFORMATION8
, 'MX'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3 || '.' || PRL_INFORMATION10 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION6 || '.' || PRL_INFORMATION7 || '.' || PRL_INFORMATION8 || '.' || PRL_INFORMATION9
, 'NL'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1
, 'SE'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3
, 'US'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION3 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION6 || '.' || PRL_INFORMATION7 || '.' || PRL_INFORMATION14 || '.' || PRL_INFORMATION8 || '.' || PRL_INFORMATION9 || '.' || PRL_INFORMATION10 || '.' || PRL_INFORMATION11 || '.' || PRL_INFORMATION12 || '.' || PRL_INFORMATION13 || '.' || PRL_INFORMATION15
, NULL))
FROM PAY_ALL_PAYROLLS_F