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

Source

View Text - Preformatted


SELECT ROWID, FIRST_NOA_INFORMATION_CAT, (DECODE (FIRST_NOA_INFORMATION_CAT, '931', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '930', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '773', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '772', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '770', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '769', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '765', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '762', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '761', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '760', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '750', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '741', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '731', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '730', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '703', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '590', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '571', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '554', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '553', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '549', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '548', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '522', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '517', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '515', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '508', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '480', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '472', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '462', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '460', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '450', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '190', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '171', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '154', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '153', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '149', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '148', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '122', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '117', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '115', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), '108', TO_DATE(FIRST_NOA_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (FIRST_NOA_INFORMATION_CAT, '352', FIRST_NOA_INFORMATION1, NULL)), (DECODE (FIRST_NOA_INFORMATION_CAT, '390', FIRST_NOA_INFORMATION1, NULL)),  
 (DECODE (FIRST_NOA_INFORMATION_CAT,  
      '108', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '115', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '117', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '122', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '148', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '149', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '153', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '154', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '171', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '190', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '352', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '390', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '450', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '460', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '462', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '472', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '480', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '508', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '515', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '517', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '522', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '548', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '549', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '553', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '554', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '571', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '590', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '703', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '730', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '731', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '741', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '750', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '760', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '761', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '762', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '765', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '769', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '770', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '772', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '773', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '930', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1,  
      '931', FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1, NULL)) 
 FROM GHR_PA_REQUESTS

View Text - HTML Formatted

SELECT ROWID
, FIRST_NOA_INFORMATION_CAT
, (DECODE (FIRST_NOA_INFORMATION_CAT
, '931'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '930'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '773'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '772'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '770'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '769'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '765'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '762'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '761'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '760'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '750'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '741'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '731'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '730'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '703'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '590'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '571'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '554'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '553'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '549'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '548'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '522'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '517'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '515'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '508'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '480'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '472'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '462'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '460'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '450'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '190'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '171'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '154'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '153'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '149'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '148'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '122'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '117'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '115'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, '108'
, TO_DATE(FIRST_NOA_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (FIRST_NOA_INFORMATION_CAT
, '352'
, FIRST_NOA_INFORMATION1
, NULL))
, (DECODE (FIRST_NOA_INFORMATION_CAT
, '390'
, FIRST_NOA_INFORMATION1
, NULL))
, (DECODE (FIRST_NOA_INFORMATION_CAT
, '108'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '115'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '117'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '122'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '148'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '149'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '153'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '154'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '171'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '190'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '352'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '390'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '450'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '460'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '462'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '472'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '480'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '508'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '515'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '517'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '522'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '548'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '549'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '553'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '554'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '571'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '590'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '703'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '730'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '731'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '741'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '750'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '760'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '761'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '762'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '765'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '769'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '770'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '772'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '773'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '930'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, '931'
, FIRST_NOA_INFORMATION_CAT || '.' || FIRST_NOA_INFORMATION1
, NULL))
FROM GHR_PA_REQUESTS