VIEW: APPS.GHR_PA_REQUESTS_DFV

Source

View Text - Preformatted

SELECT ROWID, SECOND_NOA_INFORMATION_CAT, (DECODE (SECOND_NOA_INFORMATION_CAT, '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'), '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)), SECOND_NOA_INFORMATION1, SECOND_NOA_INFORMATION1, (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, '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, NULL)) FROM GHR_PA_REQUESTS

View Text - HTML Formatted

SELECT ROWID
, SECOND_NOA_INFORMATION_CAT
, (DECODE (SECOND_NOA_INFORMATION_CAT
, '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')
, '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))
, SECOND_NOA_INFORMATION1
, SECOND_NOA_INFORMATION1
, (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
, '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
, NULL))
FROM GHR_PA_REQUESTS