SELECT UFI.SCREEN_INSTANCE_ID, UFI.FIELD_INSTANCE_ID, UFI.FIELD_ID, listagg(EC.DESCRIPTION,', ') WITHIN GROUP (order by UFI.FIELD_INSTANCE_ID) as VALUE, UFI.COMMENTS FROM USER_FIELDS UF INNER JOIN USER_FIELD_INSTANCES UFI ON UF.FIELD_ID = UFI.FIELD_ID INNER JOIN USER_FIELD_CODE_VALUES UFCV ON UFI.FIELD_INSTANCE_ID = UFCV.FIELD_INSTANCE_ID INNER JOIN EJS_CODES EC ON UFCV.CODE_TYPE = EC.CODE_TYPE AND UFCV.CODE = EC.CODE WHERE UF.TYPE_CODE_TYPE = 'USER_FIELD_TYPE_CODES' AND UF.TYPE_CODE IN('SELECT_MULTI','SELECT','AUTO_COMPLETE','RADIO') group by UFI.SCREEN_INSTANCE_ID, UFI.FIELD_INSTANCE_ID, UFI.FIELD_ID, UFI.COMMENTS UNION SELECT UFI.SCREEN_INSTANCE_ID, UFI.FIELD_INSTANCE_ID, UFI.FIELD_ID, UFCV.VALUE as VALUE, UFI.COMMENTS FROM USER_FIELDS UF INNER JOIN USER_FIELD_INSTANCES UFI ON UF.FIELD_ID = UFI.FIELD_ID INNER JOIN USER_FIELD_STR_VALUES UFCV ON UFI.FIELD_INSTANCE_ID = UFCV.FIELD_INSTANCE_ID WHERE UF.TYPE_CODE_TYPE = 'USER_FIELD_TYPE_CODES' AND UF.TYPE_CODE IN('TEXT','TEXT_AREA','CHECKBOX') UNION SELECT UFI.SCREEN_INSTANCE_ID, UFI.FIELD_INSTANCE_ID, UFI.FIELD_ID, O.TITLE || ' ' || O.FNAME || ' ' || O.LNAME || '(# '|| O.INTERNAL_ID "OFFICER", UFI.COMMENTS FROM USER_FIELDS UF INNER JOIN USER_FIELD_INSTANCES UFI ON UF.FIELD_ID = UFI.FIELD_ID INNER JOIN USER_FIELD_OFF_VALUES UFCV ON UFI.FIELD_INSTANCE_ID = UFCV.FIELD_INSTANCE_ID INNER JOIN OFFICERS O ON UFCV.OFFICER_ID = O.OFFICER_ID WHERE UF.TYPE_CODE_TYPE = 'USER_FIELD_TYPE_CODES' AND UF.TYPE_CODE = 'OFFICER'