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, '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)), INFORMATION7, (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)), INFORMATION6, INFORMATION9, INFORMATION10, INFORMATION11, INFORMATION12, INFORMATION14, INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION19, INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION27, INFORMATION13, (DECODE (INFORMATION_CATEGORY, 'NZ_NZAL', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1), NULL)),  
 (DECODE (INFORMATION_CATEGORY,  
      'AU_AUAL', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'AU_AULSL', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'AU_AUSL', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      '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
, '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))
, INFORMATION7
, (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))
, INFORMATION6
, INFORMATION9
, INFORMATION10
, INFORMATION11
, INFORMATION12
, INFORMATION14
, INFORMATION15
, INFORMATION16
, INFORMATION17
, INFORMATION19
, INFORMATION20
, INFORMATION21
, INFORMATION22
, INFORMATION27
, INFORMATION13
, (DECODE (INFORMATION_CATEGORY
, 'NZ_NZAL'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'AU_AUAL'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'AU_AULSL'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'AU_AUSL'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, '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