VIEW: APPS.PAY_ELEMENT_TEMPLATES_PREF_DFV

Source

View Text - Preformatted

SELECT ROWID, PREFERENCE_INFO_CATEGORY, (DECODE (PREFERENCE_INFO_CATEGORY, 'MX Percentage of Earnings', PREFERENCE_INFORMATION1, 'MX Hours X Rate', PREFERENCE_INFORMATION1, 'MX Flat Amount', PREFERENCE_INFORMATION1, 'MX Days X Rate', PREFERENCE_INFORMATION1, NULL)), (DECODE (PREFERENCE_INFO_CATEGORY, 'MX Percentage of Earnings', PREFERENCE_INFORMATION2, 'MX Hours X Rate', PREFERENCE_INFORMATION2, 'MX Flat Amount', PREFERENCE_INFORMATION2, 'MX Days X Rate', PREFERENCE_INFORMATION2, NULL)), (DECODE (PREFERENCE_INFO_CATEGORY, 'MX Percentage of Earnings', PREFERENCE_INFORMATION3, 'MX Hours X Rate', PREFERENCE_INFORMATION3, 'MX Flat Amount', PREFERENCE_INFORMATION3, 'MX Days X Rate', PREFERENCE_INFORMATION3, NULL)), (DECODE (PREFERENCE_INFO_CATEGORY, 'MX Percentage of Earnings', PREFERENCE_INFORMATION4, 'MX Hours X Rate', PREFERENCE_INFORMATION4, 'MX Flat Amount', PREFERENCE_INFORMATION4, 'MX Days X Rate', PREFERENCE_INFORMATION4, NULL)), (DECODE (PREFERENCE_INFO_CATEGORY, 'MX Percentage of Earnings', PREFERENCE_INFORMATION5, 'MX Hours X Rate', PREFERENCE_INFORMATION5, 'MX Flat Amount', PREFERENCE_INFORMATION5, 'MX Days X Rate', PREFERENCE_INFORMATION5, NULL)), (DECODE (PREFERENCE_INFO_CATEGORY, 'MX Percentage of Earnings', PREFERENCE_INFORMATION6, 'MX Hours X Rate', PREFERENCE_INFORMATION6, 'MX Flat Amount', PREFERENCE_INFORMATION6, 'MX Days X Rate', PREFERENCE_INFORMATION6, NULL)), (DECODE (PREFERENCE_INFO_CATEGORY, 'MX Percentage of Earnings', FND_NUMBER.CANONICAL_TO_NUMBER(PREFERENCE_INFORMATION7), 'MX Hours X Rate', FND_NUMBER.CANONICAL_TO_NUMBER(PREFERENCE_INFORMATION7), 'MX Flat Amount', FND_NUMBER.CANONICAL_TO_NUMBER(PREFERENCE_INFORMATION7), 'MX Days X Rate', FND_NUMBER.CANONICAL_TO_NUMBER(PREFERENCE_INFORMATION7), NULL)), PREFERENCE_INFORMATION8,  
 (DECODE (PREFERENCE_INFO_CATEGORY,  
      'MX Days X Rate', PREFERENCE_INFO_CATEGORY || '.' || PREFERENCE_INFORMATION1 || '.' || PREFERENCE_INFORMATION2 || '.' || PREFERENCE_INFORMATION3 || '.' || PREFERENCE_INFORMATION4 || '.' || PREFERENCE_INFORMATION5 || '.' || PREFERENCE_INFORMATION6 || '.' || PREFERENCE_INFORMATION7 || '.' || PREFERENCE_INFORMATION8,  
      'MX Flat Amount', PREFERENCE_INFO_CATEGORY || '.' || PREFERENCE_INFORMATION1 || '.' || PREFERENCE_INFORMATION2 || '.' || PREFERENCE_INFORMATION3 || '.' || PREFERENCE_INFORMATION4 || '.' || PREFERENCE_INFORMATION5 || '.' || PREFERENCE_INFORMATION6 || '.' || PREFERENCE_INFORMATION7,  
      'MX Hours X Rate', PREFERENCE_INFO_CATEGORY || '.' || PREFERENCE_INFORMATION1 || '.' || PREFERENCE_INFORMATION2 || '.' || PREFERENCE_INFORMATION3 || '.' || PREFERENCE_INFORMATION4 || '.' || PREFERENCE_INFORMATION5 || '.' || PREFERENCE_INFORMATION6 || '.' || PREFERENCE_INFORMATION7,  
      'MX Percentage of Earnings', PREFERENCE_INFO_CATEGORY || '.' || PREFERENCE_INFORMATION1 || '.' || PREFERENCE_INFORMATION2 || '.' || PREFERENCE_INFORMATION3 || '.' || PREFERENCE_INFORMATION4 || '.' || PREFERENCE_INFORMATION5 || '.' || PREFERENCE_INFORMATION6 || '.' || PREFERENCE_INFORMATION7, NULL)) 
 FROM PAY_ELEMENT_TEMPLATES

View Text - HTML Formatted

SELECT ROWID
, PREFERENCE_INFO_CATEGORY
, (DECODE (PREFERENCE_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, PREFERENCE_INFORMATION1
, 'MX HOURS X RATE'
, PREFERENCE_INFORMATION1
, 'MX FLAT AMOUNT'
, PREFERENCE_INFORMATION1
, 'MX DAYS X RATE'
, PREFERENCE_INFORMATION1
, NULL))
, (DECODE (PREFERENCE_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, PREFERENCE_INFORMATION2
, 'MX HOURS X RATE'
, PREFERENCE_INFORMATION2
, 'MX FLAT AMOUNT'
, PREFERENCE_INFORMATION2
, 'MX DAYS X RATE'
, PREFERENCE_INFORMATION2
, NULL))
, (DECODE (PREFERENCE_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, PREFERENCE_INFORMATION3
, 'MX HOURS X RATE'
, PREFERENCE_INFORMATION3
, 'MX FLAT AMOUNT'
, PREFERENCE_INFORMATION3
, 'MX DAYS X RATE'
, PREFERENCE_INFORMATION3
, NULL))
, (DECODE (PREFERENCE_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, PREFERENCE_INFORMATION4
, 'MX HOURS X RATE'
, PREFERENCE_INFORMATION4
, 'MX FLAT AMOUNT'
, PREFERENCE_INFORMATION4
, 'MX DAYS X RATE'
, PREFERENCE_INFORMATION4
, NULL))
, (DECODE (PREFERENCE_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, PREFERENCE_INFORMATION5
, 'MX HOURS X RATE'
, PREFERENCE_INFORMATION5
, 'MX FLAT AMOUNT'
, PREFERENCE_INFORMATION5
, 'MX DAYS X RATE'
, PREFERENCE_INFORMATION5
, NULL))
, (DECODE (PREFERENCE_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, PREFERENCE_INFORMATION6
, 'MX HOURS X RATE'
, PREFERENCE_INFORMATION6
, 'MX FLAT AMOUNT'
, PREFERENCE_INFORMATION6
, 'MX DAYS X RATE'
, PREFERENCE_INFORMATION6
, NULL))
, (DECODE (PREFERENCE_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, FND_NUMBER.CANONICAL_TO_NUMBER(PREFERENCE_INFORMATION7)
, 'MX HOURS X RATE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PREFERENCE_INFORMATION7)
, 'MX FLAT AMOUNT'
, FND_NUMBER.CANONICAL_TO_NUMBER(PREFERENCE_INFORMATION7)
, 'MX DAYS X RATE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PREFERENCE_INFORMATION7)
, NULL))
, PREFERENCE_INFORMATION8
, (DECODE (PREFERENCE_INFO_CATEGORY
, 'MX DAYS X RATE'
, PREFERENCE_INFO_CATEGORY || '.' || PREFERENCE_INFORMATION1 || '.' || PREFERENCE_INFORMATION2 || '.' || PREFERENCE_INFORMATION3 || '.' || PREFERENCE_INFORMATION4 || '.' || PREFERENCE_INFORMATION5 || '.' || PREFERENCE_INFORMATION6 || '.' || PREFERENCE_INFORMATION7 || '.' || PREFERENCE_INFORMATION8
, 'MX FLAT AMOUNT'
, PREFERENCE_INFO_CATEGORY || '.' || PREFERENCE_INFORMATION1 || '.' || PREFERENCE_INFORMATION2 || '.' || PREFERENCE_INFORMATION3 || '.' || PREFERENCE_INFORMATION4 || '.' || PREFERENCE_INFORMATION5 || '.' || PREFERENCE_INFORMATION6 || '.' || PREFERENCE_INFORMATION7
, 'MX HOURS X RATE'
, PREFERENCE_INFO_CATEGORY || '.' || PREFERENCE_INFORMATION1 || '.' || PREFERENCE_INFORMATION2 || '.' || PREFERENCE_INFORMATION3 || '.' || PREFERENCE_INFORMATION4 || '.' || PREFERENCE_INFORMATION5 || '.' || PREFERENCE_INFORMATION6 || '.' || PREFERENCE_INFORMATION7
, 'MX PERCENTAGE OF EARNINGS'
, PREFERENCE_INFO_CATEGORY || '.' || PREFERENCE_INFORMATION1 || '.' || PREFERENCE_INFORMATION2 || '.' || PREFERENCE_INFORMATION3 || '.' || PREFERENCE_INFORMATION4 || '.' || PREFERENCE_INFORMATION5 || '.' || PREFERENCE_INFORMATION6 || '.' || PREFERENCE_INFORMATION7
, NULL))
FROM PAY_ELEMENT_TEMPLATES