SELECT OLI.ORG_ALTERNATE_ID ALTERNATE_IDENTIFIER , OLT.SYSTEM_ID_TYPE , LKUP.MEANING FROM HZ_PARTIES HZ , IGS_PE_HZ_PARTIES IGSHZ , IGS_OR_ORG_ALT_IDS OLI , IGS_OR_ORG_ALT_IDTYP OLT , IGF_LOOKUPS_VIEW LKUP WHERE OLI.ORG_STRUCTURE_ID = IGSHZ.OSS_ORG_UNIT_CD AND IGSHZ.PARTY_ID = HZ.PARTY_ID AND OLI.ORG_ALTERNATE_ID_TYPE = OLT.ORG_ALTERNATE_ID_TYPE AND SYSDATE BETWEEN OLI.START_DATE AND NVL (END_DATE , SYSDATE) AND HZ.STATUS = 'A' AND SYSTEM_ID_TYPE = 'OPE_ID_NUM' AND LKUP.LOOKUP_TYPE = 'IGF_AP_SCHOOL_OPEID' AND LKUP.LOOKUP_CODE = OLI.ORG_ALTERNATE_ID AND LKUP.ENABLED_FLAG = 'Y' GROUP BY OLI.ORG_ALTERNATE_ID , OLT.SYSTEM_ID_TYPE , LKUP.MEANING