Product: | IGF - Financial Aid |
---|---|
Description: | Housing Status Mapping |
Implementation/DBA Data: | APPS.IGF_AP_HOUSING_MAP_V |
SELECT APM.ROWID
, APM.CI_CAL_TYPE
, APM.CI_SEQUENCE_NUMBER
, CA.START_DT
, CA.END_DT
, CA.ALTERNATE_CODE
, APM.HOUSING_STAT_CODE
, IGS.MEANING
, APM.AP_HOUSE_PLAN_CODE
, IGF.MEANING
, APM.CREATED_BY
, APM.CREATION_DATE
, APM.LAST_UPDATED_BY
, APM.LAST_UPDATE_DATE
, APM.LAST_UPDATE_LOGIN
FROM IGF_AP_HOUSING_MAP APM
, IGS_LOOKUPS_VIEW IGS
, IGF_LOOKUPS_VIEW IGF
, IGS_CA_INST CA
WHERE IGS.LOOKUP_TYPE = 'PE_TEA_PER_RES'
AND IGF.LOOKUP_TYPE = 'IGF_SCHOOL_HOUSE_TYPE'
AND IGS.LOOKUP_CODE = APM.HOUSING_STAT_CODE
AND IGF.LOOKUP_CODE = APM.AP_HOUSE_PLAN_CODE
AND CA.CAL_TYPE = APM.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = APM.CI_SEQUENCE_NUMBER