VIEW: APPS.IGF_AP_HOUSING_MAP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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