Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view contains all the inquiry program preferences - Obsolete |
Implementation/DBA Data: | Not implemented in this database |
SELECT IPF.ROWID
, IPF.INQ_PROG_PREF_ID
, IPF.PERSON_ID
, IPF.ENQUIRY_APPL_NUMBER
, IPF.INQ_PROG_CODE_ID
, IP.INQ_PROG_CODE
, IP.DESCRIPTION
, IPF.PROG_PREF_ID
, IPF.PROGRAM_APPLICATION_ID
, IPF.PROGRAM_ID
, IPF.PROGRAM_UPDATE_DATE
, IPF.REQUEST_ID
, IPF.CREATED_BY
, IPF.CREATION_DATE
, IPF.LAST_UPDATED_BY
, IPF.LAST_UPDATE_DATE
, IPF.LAST_UPDATE_LOGIN
, EAP.ENQUIRY_DT
, EAP.ENQUIRY_SOURCE_TYPE
FROM IGS_AD_I_PRG_PREFS IPF
, IGS_AD_INQ_PROGS IP
, IGS_IN_ENQUIRY_APPL EAP
WHERE IPF.INQ_PROG_CODE_ID = IP.INQ_PROG_CODE_ID
AND IPF.PERSON_ID = EAP.PERSON_ID
AND IPF.ENQUIRY_APPL_NUMBER = EAP.ENQUIRY_APPL_NUMBER