VIEW: APPS.IGF_SL_SCHOOL_CODES_V

Source

View Text - Preformatted

SELECT distinct OLI.ORG_ALTERNATE_ID ALTERNATE_IDENTIFIER, OLT.SYSTEM_ID_TYPE FROM HZ_PARTIES HZ, IGS_OR_ORG_ALT_IDS OLI, IGS_OR_ORG_ALT_IDTYP OLT WHERE OLI.ORG_STRUCTURE_ID = HZ.PARTY_NUMBER 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'

View Text - HTML Formatted

SELECT DISTINCT OLI.ORG_ALTERNATE_ID ALTERNATE_IDENTIFIER
, OLT.SYSTEM_ID_TYPE
FROM HZ_PARTIES HZ
, IGS_OR_ORG_ALT_IDS OLI
, IGS_OR_ORG_ALT_IDTYP OLT
WHERE OLI.ORG_STRUCTURE_ID = HZ.PARTY_NUMBER
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'