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_REQUESTS2_DFV

Source

View Text - Preformatted


SELECT ROWID, FIRST_LAC2_INFORMATION_CAT, (DECODE (FIRST_LAC2_INFORMATION_CAT, 'BWE', FIRST_LAC2_INFORMATION1, 'BSW', FIRST_LAC2_INFORMATION1, 'BSS', FIRST_LAC2_INFORMATION1, 'BSE', FIRST_LAC2_INFORMATION1, 'BMA', FIRST_LAC2_INFORMATION1, 'BGL', FIRST_LAC2_INFORMATION1, 'ACM', FIRST_LAC2_INFORMATION1, 'ACA', FIRST_LAC2_INFORMATION1, 'A2M', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'Z5M', TO_DATE(FIRST_LAC2_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), 'Z5L', TO_DATE(FIRST_LAC2_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), 'ABM', TO_DATE(FIRST_LAC2_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'ADM', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'ADM', TO_DATE(FIRST_LAC2_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'AXM', FIRST_LAC2_INFORMATION1, 'ASM', FIRST_LAC2_INFORMATION1, 'ARM', FIRST_LAC2_INFORMATION1, 'AGM', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'AXM', TO_DATE(FIRST_LAC2_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), 'AUL', TO_DATE(FIRST_LAC2_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), 'AGM', TO_DATE(FIRST_LAC2_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'AUL', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'AWM', TO_DATE(FIRST_LAC2_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'USM', FIRST_LAC2_INFORMATION1, 'AYM', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'AZM', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'AZM', FIRST_LAC2_INFORMATION2, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'AZM', TO_DATE(FIRST_LAC2_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'BDN', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'BEA', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'BWA', FIRST_LAC2_INFORMATION2, 'BRM', FIRST_LAC2_INFORMATION2, 'BNW', FIRST_LAC2_INFORMATION2, 'BNE', FIRST_LAC2_INFORMATION2, 'BMC', FIRST_LAC2_INFORMATION2, 'BEA', FIRST_LAC2_INFORMATION2, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'BWA', FIRST_LAC2_INFORMATION3, 'BRM', FIRST_LAC2_INFORMATION3, 'BNW', FIRST_LAC2_INFORMATION3, 'BNE', FIRST_LAC2_INFORMATION3, 'BMC', FIRST_LAC2_INFORMATION3, 'BEA', FIRST_LAC2_INFORMATION3, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'BNE', FIRST_LAC2_INFORMATION1, 'BMC', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'BNW', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'BRM', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'BWA', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'Z5M', FIRST_LAC2_INFORMATION1, 'Z5L', FIRST_LAC2_INFORMATION1, 'EJM', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'VWN', FIRST_LAC2_INFORMATION1, 'V3B', FIRST_LAC2_INFORMATION1, 'V3A', FIRST_LAC2_INFORMATION1, 'UEM', FIRST_LAC2_INFORMATION1, 'Q3E', FIRST_LAC2_INFORMATION1, 'Q3D', FIRST_LAC2_INFORMATION1, 'Q3B', FIRST_LAC2_INFORMATION2, 'Q3A', FIRST_LAC2_INFORMATION2, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'UNM', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'ZAA', FIRST_LAC2_INFORMATION1, 'UZM', FIRST_LAC2_INFORMATION1, 'UYM', FIRST_LAC2_INFORMATION1, 'USR', FIRST_LAC2_INFORMATION1, 'USP', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'ZNM', FIRST_LAC2_INFORMATION1, 'ZKM', FIRST_LAC2_INFORMATION1, 'UXM', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'VPW', FIRST_LAC2_INFORMATION1, 'VPT', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'XZM', FIRST_LAC2_INFORMATION2, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'Y5M', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'Y7M', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'Z5B', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'Z5B', FIRST_LAC2_INFORMATION2, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'Z5C', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'Z5C', FIRST_LAC2_INFORMATION2, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'ZLL', FIRST_LAC2_INFORMATION1, 'ZLK', FIRST_LAC2_INFORMATION1, 'ZLJ', FIRST_LAC2_INFORMATION1, NULL)), (DECODE (FIRST_LAC2_INFORMATION_CAT, 'ZLM', FIRST_LAC2_INFORMATION1, NULL)),  
 (DECODE (FIRST_LAC2_INFORMATION_CAT,  
      'A2M', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'ABM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'ACA', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'ACM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'ADM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2,  
      'AGM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2,  
      'ARM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'ASM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'AUL', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2,  
      'AWM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'AXM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2,  
      'AYM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'AZM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3,  
      'BDN', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'BEA', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3,  
      'BGL', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'BMA', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'BMC', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3,  
      'BNE', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3,  
      'BNW', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3,  
      'BRM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3,  
      'BSE', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'BSS', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'BSW', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'BWA', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3,  
      'BWE', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'EJM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'Q3A', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION2,  
      'Q3B', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION2,  
      'Q3D', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'Q3E', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'UEM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'UNM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'USM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'USP', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'USR', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'UXM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'UYM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'UZM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'V3A', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'V3B', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'VPT', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'VPW', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'VWN', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'XZM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION2,  
      'Y5M', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'Y7M', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'Z5B', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2,  
      'Z5C', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2,  
      'Z5L', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2, (DECODE (FIRST_LAC2_INFORMATION_CAT,  
      'Z5M', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2,  
      'ZAA', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'ZKM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'ZLJ', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'ZLK', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'ZLL', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'ZLM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1,  
      'ZNM', FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1, NULL)))) 
 FROM GHR_PA_REQUESTS

View Text - HTML Formatted

SELECT ROWID
, FIRST_LAC2_INFORMATION_CAT
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'BWE'
, FIRST_LAC2_INFORMATION1
, 'BSW'
, FIRST_LAC2_INFORMATION1
, 'BSS'
, FIRST_LAC2_INFORMATION1
, 'BSE'
, FIRST_LAC2_INFORMATION1
, 'BMA'
, FIRST_LAC2_INFORMATION1
, 'BGL'
, FIRST_LAC2_INFORMATION1
, 'ACM'
, FIRST_LAC2_INFORMATION1
, 'ACA'
, FIRST_LAC2_INFORMATION1
, 'A2M'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'Z5M'
, TO_DATE(FIRST_LAC2_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, 'Z5L'
, TO_DATE(FIRST_LAC2_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, 'ABM'
, TO_DATE(FIRST_LAC2_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'ADM'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'ADM'
, TO_DATE(FIRST_LAC2_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'AXM'
, FIRST_LAC2_INFORMATION1
, 'ASM'
, FIRST_LAC2_INFORMATION1
, 'ARM'
, FIRST_LAC2_INFORMATION1
, 'AGM'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'AXM'
, TO_DATE(FIRST_LAC2_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, 'AUL'
, TO_DATE(FIRST_LAC2_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, 'AGM'
, TO_DATE(FIRST_LAC2_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'AUL'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'AWM'
, TO_DATE(FIRST_LAC2_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'USM'
, FIRST_LAC2_INFORMATION1
, 'AYM'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'AZM'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'AZM'
, FIRST_LAC2_INFORMATION2
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'AZM'
, TO_DATE(FIRST_LAC2_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'BDN'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'BEA'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'BWA'
, FIRST_LAC2_INFORMATION2
, 'BRM'
, FIRST_LAC2_INFORMATION2
, 'BNW'
, FIRST_LAC2_INFORMATION2
, 'BNE'
, FIRST_LAC2_INFORMATION2
, 'BMC'
, FIRST_LAC2_INFORMATION2
, 'BEA'
, FIRST_LAC2_INFORMATION2
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'BWA'
, FIRST_LAC2_INFORMATION3
, 'BRM'
, FIRST_LAC2_INFORMATION3
, 'BNW'
, FIRST_LAC2_INFORMATION3
, 'BNE'
, FIRST_LAC2_INFORMATION3
, 'BMC'
, FIRST_LAC2_INFORMATION3
, 'BEA'
, FIRST_LAC2_INFORMATION3
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'BNE'
, FIRST_LAC2_INFORMATION1
, 'BMC'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'BNW'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'BRM'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'BWA'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'Z5M'
, FIRST_LAC2_INFORMATION1
, 'Z5L'
, FIRST_LAC2_INFORMATION1
, 'EJM'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'VWN'
, FIRST_LAC2_INFORMATION1
, 'V3B'
, FIRST_LAC2_INFORMATION1
, 'V3A'
, FIRST_LAC2_INFORMATION1
, 'UEM'
, FIRST_LAC2_INFORMATION1
, 'Q3E'
, FIRST_LAC2_INFORMATION1
, 'Q3D'
, FIRST_LAC2_INFORMATION1
, 'Q3B'
, FIRST_LAC2_INFORMATION2
, 'Q3A'
, FIRST_LAC2_INFORMATION2
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'UNM'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'ZAA'
, FIRST_LAC2_INFORMATION1
, 'UZM'
, FIRST_LAC2_INFORMATION1
, 'UYM'
, FIRST_LAC2_INFORMATION1
, 'USR'
, FIRST_LAC2_INFORMATION1
, 'USP'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'ZNM'
, FIRST_LAC2_INFORMATION1
, 'ZKM'
, FIRST_LAC2_INFORMATION1
, 'UXM'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'VPW'
, FIRST_LAC2_INFORMATION1
, 'VPT'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'XZM'
, FIRST_LAC2_INFORMATION2
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'Y5M'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'Y7M'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'Z5B'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'Z5B'
, FIRST_LAC2_INFORMATION2
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'Z5C'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'Z5C'
, FIRST_LAC2_INFORMATION2
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'ZLL'
, FIRST_LAC2_INFORMATION1
, 'ZLK'
, FIRST_LAC2_INFORMATION1
, 'ZLJ'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'ZLM'
, FIRST_LAC2_INFORMATION1
, NULL))
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'A2M'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'ABM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'ACA'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'ACM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'ADM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2
, 'AGM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2
, 'ARM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'ASM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'AUL'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2
, 'AWM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'AXM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2
, 'AYM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'AZM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3
, 'BDN'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'BEA'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3
, 'BGL'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'BMA'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'BMC'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3
, 'BNE'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3
, 'BNW'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3
, 'BRM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3
, 'BSE'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'BSS'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'BSW'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'BWA'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2 || '.' || FIRST_LAC2_INFORMATION3
, 'BWE'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'EJM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'Q3A'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION2
, 'Q3B'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION2
, 'Q3D'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'Q3E'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'UEM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'UNM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'USM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'USP'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'USR'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'UXM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'UYM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'UZM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'V3A'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'V3B'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'VPT'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'VPW'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'VWN'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'XZM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION2
, 'Y5M'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'Y7M'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'Z5B'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2
, 'Z5C'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2
, 'Z5L'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2
, (DECODE (FIRST_LAC2_INFORMATION_CAT
, 'Z5M'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1 || '.' || FIRST_LAC2_INFORMATION2
, 'ZAA'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'ZKM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'ZLJ'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'ZLK'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'ZLL'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'ZLM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, 'ZNM'
, FIRST_LAC2_INFORMATION_CAT || '.' || FIRST_LAC2_INFORMATION1
, NULL))))
FROM GHR_PA_REQUESTS