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_F_DFV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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