VIEW: APPS.IGF_AP_SCHOOL_OPEID_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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