SELECT B.DISPLAYED_FIELD AS DISPLAYED_LOOKUP_TYPE , A.LOOKUP_CODE AS LOOKUP_CODE , A.DISPLAYED_FIELD AS DISPLAYED_FIELD , A.LOOKUP_TYPE AS LOOKUP_TYPE , A.DESCRIPTION AS DESCRIPTION , A.INACTIVE_DATE AS INACTIVE_DATE , 200 AS APPLICATION_ID , A.ROWID AS ROW_ID FROM PO_LOOKUP_CODES A , PO_LOOKUP_CODES B WHERE B.LOOKUP_CODE = A.LOOKUP_TYPE AND A.LOOKUP_TYPE IN (SELECT LOOKUP_TYPE FROM AP_LOOKUP_TYPES WHERE USER_UPDATABLE_FLAG = 'Y') UNION SELECT D.DISPLAYED_FIELD AS DISPLAYED_LOOKUP_TYPE , C.LOOKUP_CODE AS LOOKUP_CODE , C.DISPLAYED_FIELD AS DISPLAYED_FIELD , C.LOOKUP_TYPE AS LOOKUP_TYPE , C.DESCRIPTION AS DESCRIPTION , C.INACTIVE_DATE AS INACTIVE_DATE , 201 AS APPLICATION_ID , C.ROWID AS ROW_ID FROM PO_LOOKUP_CODES C , PO_LOOKUP_CODES D WHERE D.LOOKUP_CODE = C.LOOKUP_TYPE AND C.LOOKUP_TYPE IN ('PAY GROUP' , 'VENDOR TYPE' , 'SHIP VIA' , 'FOB' , 'MINORITY GROUP' , 'FREIGHT TERMS')