View: IGF_SL_CL_SETUP_ORG_V

Product:	IGF - Financial Aid
Description:	FFELP Organization Unit
Implementation/DBA Data:	APPS.IGF_SL_CL_SETUP_ORG_V

View Text

SELECT DISTINCT AWDYR.CI_CAL_TYPE
, AWDYR.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, CA.START_DT
, CA.END_DT
, CLSET.PARTY_ID
, ORGV.PARTY_NUMBER
, ORGV.PARTY_NAME
FROM IGF_AP_BATCH_AW_MAP AWDYR
, IGF_SL_CL_SETUP CLSET
, IGS_OR_INST_ORG_BASE_V ORGV
, IGS_CA_INST CA
WHERE AWDYR.CI_CAL_TYPE = CA.CAL_TYPE
AND AWDYR.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER
AND AWDYR.CI_CAL_TYPE = CLSET.CI_CAL_TYPE
AND AWDYR.CI_SEQUENCE_NUMBER = CLSET.CI_SEQUENCE_NUMBER
AND ORGV.PARTY_ID = CLSET.PARTY_ID

Columns