SELECT US.UOO_ID , TR.ORG_UNIT_CD FROM IGS_PS_UNIT_OFR_OPT_ALL US , IGS_PS_TCH_RESP TR WHERE TR.UNIT_CD = US.UNIT_CD AND TR.VERSION_NUMBER = US.VERSION_NUMBER AND NOT EXISTS ( SELECT 1 FROM IGS_PS_TCH_RESP_OVRD_ALL OVRD WHERE OVRD.UOO_ID = US.UOO_ID ) UNION SELECT US.UOO_ID , TRO.ORG_UNIT_CD FROM IGS_PS_UNIT_OFR_OPT_ALL US , IGS_PS_TCH_RESP_OVRD_ALL TRO WHERE TRO.UOO_ID = US.UOO_ID