View: IGS_IN_ENQUIRY_APPL_V

View Text

SELECT EAP.ROWID
, EAP.PERSON_ID
, PDV.PERSON_NUMBER
, EAP.ENQUIRY_APPL_NUMBER
, EAP.ACAD_CAL_TYPE
, EAP.ACAD_CI_SEQUENCE_NUMBER
, EAP.ADM_CAL_TYPE
, EAP.ADM_CI_SEQUENCE_NUMBER
, EAP.ENQUIRY_STATUS
, LKUPV.LOOKUP_CODE
, LKUPV.MEANING
, LKUPV.CLOSED_IND
, ESTY.DESCRIPTION
, ESTY.CLOSED_IND
, EAP.ENQUIRY_DT
, EAP.ENQUIRY_SOURCE_TYPE
, EAP.INQ_ENTRY_STAT_ID
, IES.INQ_ENTRY_STAT
, IES.DESCRIPTION
, EAP.INQ_ENTRY_LEVEL_ID
, IEL.INQ_ENTRY_LEVEL
, IEL.DESCRIPTION
, EAP.EDU_GOAL_ID
, CC1.NAME
, CC1.DESCRIPTION
, EAP.PARTY_ID
, OU.PARTY_NUMBER
, OU.PARTY_NAME
, EAP.HOW_KNOWUS_ID
, CC2.NAME
, CC2.DESCRIPTION
, EAP.WHO_INFLUENCED_ID
, CC3.NAME
, CC3.DESCRIPTION
, EAP.REGISTERING_PERSON_ID
, PDV.PREFERRED_NAME
, EAP.OVERRIDE_PROCESS_IND
, EAP.INDICATED_MAILING_DT
, EAP.LAST_PROCESS_DT
, EAP.COMMENTS
, EAP.REQUEST_ID
, EAP.PROGRAM_APPLICATION_ID
, EAP.PROGRAM_ID
, EAP.PROGRAM_UPDATE_DATE
, EAP.CREATED_BY
, EAP.CREATION_DATE
, EAP.LAST_UPDATED_BY
, EAP.LAST_UPDATE_DATE
, EAP.LAST_UPDATE_LOGIN
, PDV.PREFERRED_GIVEN_NAME
, EAP.ATTRIBUTE_CATEGORY
, EAP.ATTRIBUTE1
, EAP.ATTRIBUTE2
, EAP.ATTRIBUTE3
, EAP.ATTRIBUTE4
, EAP.ATTRIBUTE5
, EAP.ATTRIBUTE6
, EAP.ATTRIBUTE7
, EAP.ATTRIBUTE8
, EAP.ATTRIBUTE9
, EAP.ATTRIBUTE10
, EAP.ATTRIBUTE11
, EAP.ATTRIBUTE12
, EAP.ATTRIBUTE13
, EAP.ATTRIBUTE14
, EAP.ATTRIBUTE15
, EAP.ATTRIBUTE16
, EAP.ATTRIBUTE17
, EAP.ATTRIBUTE18
, EAP.ATTRIBUTE19
, EAP.ATTRIBUTE20
, CI.ALTERNATE_CODE ADM_ALTERNATE_CODE
, SATV.SCHOOL_APPLYING_TO
FROM IGS_IN_ENQUIRY_APPL EAP
, IGS_LOOKUPS_VIEW LKUPV
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
, IGS_AD_CODE_CLASSES CC3
, IGS_AD_I_ENTRY_STATS IES
, IGS_AD_I_ENTRY_LVLS IEL
, HZ_PARTIES OU
, IGS_IN_ENQ_STATUS ES
, IGS_IN_ENQ_SRC_TYPE ESTY
, IGS_PE_PERSON_V PDV
, IGS_CA_INST CI
, IGS_AD_SCHL_APLY_TO_V SATV
WHERE LKUPV.LOOKUP_TYPE = 'ENQUIRY_STATUS'
AND LKUPV.LOOKUP_CODE = ES.S_ENQUIRY_STATUS
AND ES.ENQUIRY_STATUS = EAP.ENQUIRY_STATUS
AND IES.INQ_ENTRY_STAT_ID(+) = EAP.INQ_ENTRY_STAT_ID
AND IEL.INQ_ENTRY_LEVEL_ID(+) = EAP.INQ_ENTRY_LEVEL_ID
AND CC1.CODE_ID(+) = EAP.EDU_GOAL_ID
AND OU.PARTY_ID(+) = EAP.PARTY_ID
AND CC2.CODE_ID(+) = EAP.HOW_KNOWUS_ID
AND CC3.CODE_ID(+) = EAP.WHO_INFLUENCED_ID
AND ESTY.ENQUIRY_SOURCE_TYPE = EAP.ENQUIRY_SOURCE_TYPE
AND ESTY.CLOSED_IND = 'N'
AND PDV.PERSON_ID(+) = EAP.REGISTERING_PERSON_ID
AND CI.CAL_TYPE = EAP.ADM_CAL_TYPE
AND CI.SEQUENCE_NUMBER = EAP.ADM_CI_SEQUENCE_NUMBER
AND EAP.PARTY_ID = SATV.PARTY_ID(+)

Columns