View: IGF_AP_SCHOOL_OPEID_V

Product:	IGF - Financial Aid
Description:	Holds distinct OPE ID codes and their descriptions
Implementation/DBA Data:	APPS.IGF_AP_SCHOOL_OPEID_V

View Text

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

Columns