Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view will be based on OSO public view AS_INTEREST_CODES_VL. We will expose only attributes in that VL that OSS needs |
Implementation/DBA Data: | Not implemented in this database |
SELECT IPU.ROWID ROW_ID
, IPU.INTEREST_CODE_ID INQ_PROG_UNIT_SET_ID
, IPU.PARENT_INTEREST_CODE_ID INQ_PROG_CODE_ID
, RES.INTEREST_TYPE_ID INTEREST_TYPE_ID
, RES.INQ_ENTRY_STAT_ID INQ_ENTRY_STAT_ID
, IPU.CODE INQ_UNIT_SET_CODE
, IPU.DESCRIPTION UNIT_SET_CODE_DESCRIPTION
, IPU.MASTER_ENABLED_FLAG
, IPU.CREATED_BY
, IPU.CREATION_DATE
, IPU.LAST_UPDATED_BY
, IPU.LAST_UPDATE_DATE
, IPU.LAST_UPDATE_LOGIN
FROM AS_INTEREST_CODES_VL IPU
, IGS_RC_I_ENT_STATS RES
WHERE IPU.PARENT_INTEREST_CODE_ID IS NOT NULL
AND IPU.INTEREST_TYPE_ID = RES.INTEREST_TYPE_ID