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_ACCRUAL_PLANS_DFV

Source

View Text - Preformatted


SELECT ROWID, INFORMATION_CATEGORY, (DECODE (INFORMATION_CATEGORY, 'AU_AUSL', INFORMATION1, 'AU_AULSL', INFORMATION1, 'AU_AUAL', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'AU_AUSL', INFORMATION2, 'AU_AULSL', INFORMATION2, 'AU_AUAL', INFORMATION2, NULL)), (DECODE (INFORMATION_CATEGORY, 'AU_AUSL', INFORMATION3, 'AU_AULSL', INFORMATION3, 'AU_AUAL', INFORMATION3, NULL)), (DECODE (INFORMATION_CATEGORY, 'AU_AUSL', INFORMATION4, 'AU_AULSL', INFORMATION4, 'AU_AUAL', INFORMATION4, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1), 'FR_FR_MAIN_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1), 'FR_FR_ADDITIONAL_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2), 'FR_FR_MAIN_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2), 'FR_FR_ADDITIONAL_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3), 'FR_FR_MAIN_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3), 'FR_FR_ADDITIONAL_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION7, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', INFORMATION8, 'FR_FR_MAIN_HOLIDAY', INFORMATION8, 'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION8, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION13, 'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION13, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', INFORMATION18, 'FR_FR_MAIN_HOLIDAY', INFORMATION18, 'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION18, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', INFORMATION23, 'FR_FR_MAIN_HOLIDAY', INFORMATION23, 'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION23, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', INFORMATION24, 'FR_FR_MAIN_HOLIDAY', INFORMATION24, 'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION24, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', INFORMATION25, 'FR_FR_MAIN_HOLIDAY', INFORMATION25, 'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION25, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', INFORMATION26, 'FR_FR_MAIN_HOLIDAY', INFORMATION26, 'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION26, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', INFORMATION28, 'FR_FR_MAIN_HOLIDAY', INFORMATION28, 'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION28, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', INFORMATION29, 'FR_FR_MAIN_HOLIDAY', INFORMATION29, 'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION29, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', INFORMATION30, 'FR_FR_MAIN_HOLIDAY', INFORMATION30, 'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION30, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION4), 'FR_FR_MAIN_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION4), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION5), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION6, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION9, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION10, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION11, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION12, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION14, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION15, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION16, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION17, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION19, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION20, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION21, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION22, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_MAIN_HOLIDAY', INFORMATION27, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_RTT_HOLIDAY', INFORMATION13, NULL)), (DECODE (INFORMATION_CATEGORY, 'NZ_NZAL', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1), NULL)),  
 (DECODE (INFORMATION_CATEGORY,  
      'AU_AUAL', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4,  
      'AU_AULSL', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4,  
      'AU_AUSL', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4,  
      'FR_FR_ADDITIONAL_HOLIDAY', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION7 || '.' || INFORMATION8 || '.' || INFORMATION13 || '.' || INFORMATION18 || '.' || INFORMATION23 || '.' || INFORMATION24 || '.' || INFORMATION25 || '.' || INFORMATION26 || '.' || INFORMATION28 || '.' || INFORMATION29 || '.' || INFORMATION30,  
      'FR_FR_MAIN_HOLIDAY', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION8 || '.' || INFORMATION9 || '.' || INFORMATION10 || '.' || INFORMATION11 || '.' || INFORMATION12 || '.' || INFORMATION13 || '.' || INFORMATION14 || '.' || INFORMATION15 || '.' || INFORMATION16 || '.' || INFORMATION17 || '.' || INFORMATION18 || '.' || INFORMATION19 || '.' || INFORMATION20 || '.' || INFORMATION21 || '.' || INFORMATION22 || '.' || INFORMATION23 || '.' || INFORMATION24 || '.' || INFORMATION25 || '.' || INFORMATION26 || '.' || INFORMATION27 || '.' || INFORMATION28 || '.' || INFORMATION29 || '.' || INFORMATION30,  
      'FR_FR_RTT_HOLIDAY', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION8 || '.' || INFORMATION13 || '.' || INFORMATION18 || '.' || INFORMATION23 || '.' || INFORMATION24 || '.' || INFORMATION25 || '.' || INFORMATION26 || '.' || INFORMATION28 || '.' || INFORMATION29 || '.' || INFORMATION30,  
      'NZ_NZAL', INFORMATION_CATEGORY || '.' || INFORMATION1, NULL)) 
 FROM PAY_ACCRUAL_PLANS

View Text - HTML Formatted

SELECT ROWID
, INFORMATION_CATEGORY
, (DECODE (INFORMATION_CATEGORY
, 'AU_AUSL'
, INFORMATION1
, 'AU_AULSL'
, INFORMATION1
, 'AU_AUAL'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'AU_AUSL'
, INFORMATION2
, 'AU_AULSL'
, INFORMATION2
, 'AU_AUAL'
, INFORMATION2
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'AU_AUSL'
, INFORMATION3
, 'AU_AULSL'
, INFORMATION3
, 'AU_AUAL'
, INFORMATION3
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'AU_AUSL'
, INFORMATION4
, 'AU_AULSL'
, INFORMATION4
, 'AU_AUAL'
, INFORMATION4
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1)
, 'FR_FR_MAIN_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1)
, 'FR_FR_ADDITIONAL_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2)
, 'FR_FR_MAIN_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2)
, 'FR_FR_ADDITIONAL_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3)
, 'FR_FR_MAIN_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3)
, 'FR_FR_ADDITIONAL_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION7
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, INFORMATION8
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION8
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION8
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION13
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION13
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, INFORMATION18
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION18
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION18
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, INFORMATION23
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION23
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION23
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, INFORMATION24
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION24
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION24
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, INFORMATION25
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION25
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION25
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, INFORMATION26
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION26
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION26
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, INFORMATION28
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION28
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION28
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, INFORMATION29
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION29
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION29
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, INFORMATION30
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION30
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION30
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION4)
, 'FR_FR_MAIN_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION4)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION5)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION6
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION9
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION10
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION11
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION12
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION14
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION15
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION16
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION17
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION19
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION20
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION21
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION22
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION27
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_RTT_HOLIDAY'
, INFORMATION13
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'NZ_NZAL'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'AU_AUAL'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4
, 'AU_AULSL'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4
, 'AU_AUSL'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4
, 'FR_FR_ADDITIONAL_HOLIDAY'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION7 || '.' || INFORMATION8 || '.' || INFORMATION13 || '.' || INFORMATION18 || '.' || INFORMATION23 || '.' || INFORMATION24 || '.' || INFORMATION25 || '.' || INFORMATION26 || '.' || INFORMATION28 || '.' || INFORMATION29 || '.' || INFORMATION30
, 'FR_FR_MAIN_HOLIDAY'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION8 || '.' || INFORMATION9 || '.' || INFORMATION10 || '.' || INFORMATION11 || '.' || INFORMATION12 || '.' || INFORMATION13 || '.' || INFORMATION14 || '.' || INFORMATION15 || '.' || INFORMATION16 || '.' || INFORMATION17 || '.' || INFORMATION18 || '.' || INFORMATION19 || '.' || INFORMATION20 || '.' || INFORMATION21 || '.' || INFORMATION22 || '.' || INFORMATION23 || '.' || INFORMATION24 || '.' || INFORMATION25 || '.' || INFORMATION26 || '.' || INFORMATION27 || '.' || INFORMATION28 || '.' || INFORMATION29 || '.' || INFORMATION30
, 'FR_FR_RTT_HOLIDAY'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION8 || '.' || INFORMATION13 || '.' || INFORMATION18 || '.' || INFORMATION23 || '.' || INFORMATION24 || '.' || INFORMATION25 || '.' || INFORMATION26 || '.' || INFORMATION28 || '.' || INFORMATION29 || '.' || INFORMATION30
, 'NZ_NZAL'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, NULL))
FROM PAY_ACCRUAL_PLANS