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_REQUESTS5_DFV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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