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.PER_PERIODS_OF_SERVICE1_DFV

Source

View Text - Preformatted


SELECT ROWID, PDS_INFORMATION_CATEGORY, (DECODE (PDS_INFORMATION_CATEGORY, 'AU', PDS_INFORMATION1, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'AU', PDS_INFORMATION2, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'AU', PDS_INFORMATION3, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'AU', PDS_INFORMATION11, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'AU', TO_DATE(PDS_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'AU', PDS_INFORMATION12, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'AU', PDS_INFORMATION6, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'AU', PDS_INFORMATION7, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'AU', PDS_INFORMATION8, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'AU', PDS_INFORMATION9, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'AU', PDS_INFORMATION10, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'BE', PDS_INFORMATION1, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'BE', PDS_INFORMATION2, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'BE', PDS_INFORMATION3, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'BE', PDS_INFORMATION4, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'BE', PDS_INFORMATION5, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'BE', PDS_INFORMATION6, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'BE', PDS_INFORMATION7, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'BE', PDS_INFORMATION8, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'CA', PDS_INFORMATION1, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'CA', PDS_INFORMATION2, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'ES', TO_DATE(PDS_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'ES', PDS_INFORMATION5, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'ES', FND_NUMBER.CANONICAL_TO_NUMBER(PDS_INFORMATION6), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'ES', FND_NUMBER.CANONICAL_TO_NUMBER(PDS_INFORMATION7), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'ES', FND_NUMBER.CANONICAL_TO_NUMBER(PDS_INFORMATION8), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'ES', TO_DATE(PDS_INFORMATION9, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'ES', TO_DATE(PDS_INFORMATION10, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', PDS_INFORMATION1, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', PDS_INFORMATION2, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', PDS_INFORMATION3, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', PDS_INFORMATION4, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', PDS_INFORMATION5, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', PDS_INFORMATION6, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', PDS_INFORMATION7, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', TO_DATE(PDS_INFORMATION8, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', TO_DATE(PDS_INFORMATION9, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', TO_DATE(PDS_INFORMATION10, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', PDS_INFORMATION11, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', PDS_INFORMATION12, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', TO_DATE(PDS_INFORMATION13, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', TO_DATE(PDS_INFORMATION14, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'FR', TO_DATE(PDS_INFORMATION15, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'HK', TO_DATE(PDS_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'HK', PDS_INFORMATION2, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'HK', PDS_INFORMATION7, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'HK', PDS_INFORMATION8, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'HK', PDS_INFORMATION3, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'HK', TO_DATE(PDS_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'HK', PDS_INFORMATION5, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'HK', PDS_INFORMATION6, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'IN', PDS_INFORMATION1, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'IN', PDS_INFORMATION2, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'IN', PDS_INFORMATION3, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'MX', PDS_INFORMATION1, NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'NL', TO_DATE(PDS_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'NL', TO_DATE(PDS_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'NL', TO_DATE(PDS_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PDS_INFORMATION_CATEGORY, 'SA', PDS_INFORMATION1, NULL)),  
 (DECODE (PDS_INFORMATION_CATEGORY,  
      'AU', PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION3 || '.' || PDS_INFORMATION11 || '.' || PDS_INFORMATION5 || '.' || PDS_INFORMATION12 || '.' || PDS_INFORMATION6 || '.' || PDS_INFORMATION7 || '.' || PDS_INFORMATION8 || '.' || PDS_INFORMATION9 || '.' || PDS_INFORMATION10,  
      'BE', PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION3 || '.' || PDS_INFORMATION4 || '.' || PDS_INFORMATION5 || '.' || PDS_INFORMATION6 || '.' || PDS_INFORMATION7 || '.' || PDS_INFORMATION8,  
      'CA', PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2,  
      'ES', PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION5 || '.' || PDS_INFORMATION6 || '.' || PDS_INFORMATION7 || '.' || PDS_INFORMATION8 || '.' || PDS_INFORMATION9 || '.' || PDS_INFORMATION10,  
      'FR', PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION3 || '.' || PDS_INFORMATION4 || '.' || PDS_INFORMATION5 || '.' || PDS_INFORMATION6 || '.' || PDS_INFORMATION7 || '.' || PDS_INFORMATION8 || '.' || PDS_INFORMATION9 || '.' || PDS_INFORMATION10 || '.' || PDS_INFORMATION11 || '.' || PDS_INFORMATION12 || '.' || PDS_INFORMATION13 || '.' || PDS_INFORMATION14 || '.' || PDS_INFORMATION15,  
      'HK', PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION7 || '.' || PDS_INFORMATION8 || '.' || PDS_INFORMATION3 || '.' || PDS_INFORMATION4 || '.' || PDS_INFORMATION5 || '.' || PDS_INFORMATION6,  
      'IN', PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION3,  
      'MX', PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1,  
      'NL', PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION3,  
      'SA', PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1, NULL)) 
 FROM PER_PERIODS_OF_SERVICE

View Text - HTML Formatted

SELECT ROWID
, PDS_INFORMATION_CATEGORY
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, PDS_INFORMATION1
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, PDS_INFORMATION2
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, PDS_INFORMATION3
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, PDS_INFORMATION11
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, TO_DATE(PDS_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, PDS_INFORMATION12
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, PDS_INFORMATION6
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, PDS_INFORMATION7
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, PDS_INFORMATION8
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, PDS_INFORMATION9
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, PDS_INFORMATION10
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'BE'
, PDS_INFORMATION1
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'BE'
, PDS_INFORMATION2
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'BE'
, PDS_INFORMATION3
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'BE'
, PDS_INFORMATION4
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'BE'
, PDS_INFORMATION5
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'BE'
, PDS_INFORMATION6
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'BE'
, PDS_INFORMATION7
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'BE'
, PDS_INFORMATION8
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'CA'
, PDS_INFORMATION1
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'CA'
, PDS_INFORMATION2
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'ES'
, TO_DATE(PDS_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'ES'
, PDS_INFORMATION5
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'ES'
, FND_NUMBER.CANONICAL_TO_NUMBER(PDS_INFORMATION6)
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'ES'
, FND_NUMBER.CANONICAL_TO_NUMBER(PDS_INFORMATION7)
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'ES'
, FND_NUMBER.CANONICAL_TO_NUMBER(PDS_INFORMATION8)
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'ES'
, TO_DATE(PDS_INFORMATION9
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'ES'
, TO_DATE(PDS_INFORMATION10
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, PDS_INFORMATION1
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, PDS_INFORMATION2
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, PDS_INFORMATION3
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, PDS_INFORMATION4
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, PDS_INFORMATION5
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, PDS_INFORMATION6
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, PDS_INFORMATION7
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(PDS_INFORMATION8
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(PDS_INFORMATION9
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(PDS_INFORMATION10
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, PDS_INFORMATION11
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, PDS_INFORMATION12
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(PDS_INFORMATION13
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(PDS_INFORMATION14
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'FR'
, TO_DATE(PDS_INFORMATION15
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'HK'
, TO_DATE(PDS_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'HK'
, PDS_INFORMATION2
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'HK'
, PDS_INFORMATION7
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'HK'
, PDS_INFORMATION8
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'HK'
, PDS_INFORMATION3
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'HK'
, TO_DATE(PDS_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'HK'
, PDS_INFORMATION5
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'HK'
, PDS_INFORMATION6
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'IN'
, PDS_INFORMATION1
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'IN'
, PDS_INFORMATION2
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'IN'
, PDS_INFORMATION3
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'MX'
, PDS_INFORMATION1
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'NL'
, TO_DATE(PDS_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'NL'
, TO_DATE(PDS_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'NL'
, TO_DATE(PDS_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'SA'
, PDS_INFORMATION1
, NULL))
, (DECODE (PDS_INFORMATION_CATEGORY
, 'AU'
, PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION3 || '.' || PDS_INFORMATION11 || '.' || PDS_INFORMATION5 || '.' || PDS_INFORMATION12 || '.' || PDS_INFORMATION6 || '.' || PDS_INFORMATION7 || '.' || PDS_INFORMATION8 || '.' || PDS_INFORMATION9 || '.' || PDS_INFORMATION10
, 'BE'
, PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION3 || '.' || PDS_INFORMATION4 || '.' || PDS_INFORMATION5 || '.' || PDS_INFORMATION6 || '.' || PDS_INFORMATION7 || '.' || PDS_INFORMATION8
, 'CA'
, PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2
, 'ES'
, PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION5 || '.' || PDS_INFORMATION6 || '.' || PDS_INFORMATION7 || '.' || PDS_INFORMATION8 || '.' || PDS_INFORMATION9 || '.' || PDS_INFORMATION10
, 'FR'
, PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION3 || '.' || PDS_INFORMATION4 || '.' || PDS_INFORMATION5 || '.' || PDS_INFORMATION6 || '.' || PDS_INFORMATION7 || '.' || PDS_INFORMATION8 || '.' || PDS_INFORMATION9 || '.' || PDS_INFORMATION10 || '.' || PDS_INFORMATION11 || '.' || PDS_INFORMATION12 || '.' || PDS_INFORMATION13 || '.' || PDS_INFORMATION14 || '.' || PDS_INFORMATION15
, 'HK'
, PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION7 || '.' || PDS_INFORMATION8 || '.' || PDS_INFORMATION3 || '.' || PDS_INFORMATION4 || '.' || PDS_INFORMATION5 || '.' || PDS_INFORMATION6
, 'IN'
, PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION3
, 'MX'
, PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1
, 'NL'
, PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1 || '.' || PDS_INFORMATION2 || '.' || PDS_INFORMATION3
, 'SA'
, PDS_INFORMATION_CATEGORY || '.' || PDS_INFORMATION1
, NULL))
FROM PER_PERIODS_OF_SERVICE