Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view contains all the inquiry unit sets preferences - Obsolete |
Implementation/DBA Data: | Not implemented in this database |
SELECT IUF.ROWID
, IUF.INQ_UNIT_SET_PREF_ID
, IUF.PERSON_ID
, IUF.ENQUIRY_APPL_NUMBER
, IUF.INQ_UNIT_SET_CODE_ID
, IU.INQ_UNIT_SET_CODE
, IU.DESCRIPTION
, IUF.UNIT_SET_PREF_ID
, IUF.PROGRAM_APPLICATION_ID
, IUF.PROGRAM_ID
, IUF.PROGRAM_UPDATE_DATE
, IUF.REQUEST_ID
, IUF.CREATED_BY
, IUF.CREATION_DATE
, IUF.LAST_UPDATED_BY
, IUF.LAST_UPDATE_DATE
, IUF.LAST_UPDATE_LOGIN
, EAP.ENQUIRY_DT
, EAP.ENQUIRY_SOURCE_TYPE
FROM IGS_AD_I_USET_PREFS IUF
, IGS_AD_INQ_UNIT_SETS IU
, IGS_IN_ENQUIRY_APPL EAP
WHERE IUF.INQ_UNIT_SET_CODE_ID = IU.INQ_UNIT_SET_CODE_ID
AND IUF.PERSON_ID = EAP.PERSON_ID
AND IUF.ENQUIRY_APPL_NUMBER = EAP.ENQUIRY_APPL_NUMBER