VIEW: APPS.IGS_IN_ENQUIRY_APPL_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)