SELECT ROWID, PRL_INFORMATION_CATEGORY, PRL_INFORMATION1, PRL_INFORMATION2, PRL_INFORMATION3, PRL_INFORMATION4, (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)), PRL_INFORMATION1, PRL_INFORMATION1, PRL_INFORMATION1, (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)), PRL_INFORMATION5, PRL_INFORMATION6, (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)), PRL_INFORMATION11, PRL_INFORMATION12, (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)), PRL_INFORMATION16, (DECODE (PRL_INFORMATION_CATEGORY, 'FR', TO_DATE(PRL_INFORMATION17, 'YYYY/MM/DD HH24:MI:SS'), NULL)), PRL_INFORMATION18, PRL_INFORMATION19, PRL_INFORMATION1, PRL_INFORMATION2, PRL_INFORMATION4, PRL_INFORMATION5, PRL_INFORMATION3, PRL_INFORMATION1, PRL_INFORMATION7, PRL_INFORMATION2, PRL_INFORMATION3, (DECODE (PRL_INFORMATION_CATEGORY, 'KR', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION4), NULL)), PRL_INFORMATION5, PRL_INFORMATION6, PRL_INFORMATION1, PRL_INFORMATION2, PRL_INFORMATION3, PRL_INFORMATION10, PRL_INFORMATION4, PRL_INFORMATION5, PRL_INFORMATION6, PRL_INFORMATION7, PRL_INFORMATION8, PRL_INFORMATION9, PRL_INFORMATION1, PRL_INFORMATION1, PRL_INFORMATION2, PRL_INFORMATION3, PRL_INFORMATION2, PRL_INFORMATION3, PRL_INFORMATION4, PRL_INFORMATION7, PRL_INFORMATION14, PRL_INFORMATION8, (DECODE (PRL_INFORMATION_CATEGORY, 'US', FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION9), NULL)), PRL_INFORMATION10, PRL_INFORMATION11, PRL_INFORMATION12, PRL_INFORMATION13,
(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,
'JP', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION3,
'KR', PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION7 || '.' || 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, NULL))
FROM PAY_ALL_PAYROLLS_F
SELECT ROWID
, PRL_INFORMATION_CATEGORY
, PRL_INFORMATION1
, PRL_INFORMATION2
, PRL_INFORMATION3
, PRL_INFORMATION4
, (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))
, PRL_INFORMATION1
, PRL_INFORMATION1
, PRL_INFORMATION1
, (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))
, PRL_INFORMATION5
, PRL_INFORMATION6
, (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))
, PRL_INFORMATION11
, PRL_INFORMATION12
, (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))
, PRL_INFORMATION16
, (DECODE (PRL_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(PRL_INFORMATION17
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, PRL_INFORMATION18
, PRL_INFORMATION19
, PRL_INFORMATION1
, PRL_INFORMATION2
, PRL_INFORMATION4
, PRL_INFORMATION5
, PRL_INFORMATION3
, PRL_INFORMATION1
, PRL_INFORMATION7
, PRL_INFORMATION2
, PRL_INFORMATION3
, (DECODE (PRL_INFORMATION_CATEGORY
, 'KR'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION4)
, NULL))
, PRL_INFORMATION5
, PRL_INFORMATION6
, PRL_INFORMATION1
, PRL_INFORMATION2
, PRL_INFORMATION3
, PRL_INFORMATION10
, PRL_INFORMATION4
, PRL_INFORMATION5
, PRL_INFORMATION6
, PRL_INFORMATION7
, PRL_INFORMATION8
, PRL_INFORMATION9
, PRL_INFORMATION1
, PRL_INFORMATION1
, PRL_INFORMATION2
, PRL_INFORMATION3
, PRL_INFORMATION2
, PRL_INFORMATION3
, PRL_INFORMATION4
, PRL_INFORMATION7
, PRL_INFORMATION14
, PRL_INFORMATION8
, (DECODE (PRL_INFORMATION_CATEGORY
, 'US'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRL_INFORMATION9)
, NULL))
, PRL_INFORMATION10
, PRL_INFORMATION11
, PRL_INFORMATION12
, PRL_INFORMATION13
,
(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
,
'JP'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION2 || '.' || PRL_INFORMATION4 || '.' || PRL_INFORMATION5 || '.' || PRL_INFORMATION3
,
'KR'
, PRL_INFORMATION_CATEGORY || '.' || PRL_INFORMATION1 || '.' || PRL_INFORMATION7 || '.' || 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
, NULL))
FROM PAY_ALL_PAYROLLS_F
|
|
|