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_REQUESTS6_DFV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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