View: IGS_DA_CNFG_REQ_TYP_V

View Text

SELECT DAC.ROWID ROW_ID
, DAC.REQUEST_TYPE_ID
, DAC.REQUEST_TYPE
, DAC.REQUEST_TYPE_COMMENT
, DAC.ATTRIBUTE_CATEGORY
, DAC.ATTRIBUTE1
, DAC.ATTRIBUTE2
, DAC.ATTRIBUTE3
, DAC.ATTRIBUTE4
, DAC.ATTRIBUTE5
, DAC.ATTRIBUTE6
, DAC.ATTRIBUTE7
, DAC.ATTRIBUTE8
, DAC.ATTRIBUTE9
, DAC.ATTRIBUTE10
, DAC.ATTRIBUTE11
, DAC.ATTRIBUTE12
, DAC.ATTRIBUTE13
, DAC.ATTRIBUTE14
, DAC.ATTRIBUTE15
, DAC.ATTRIBUTE16
, DAC.ATTRIBUTE17
, DAC.ATTRIBUTE18
, DAC.ATTRIBUTE19
, DAC.ATTRIBUTE20
, DAC.CREATION_DATE
, DAC.CREATED_BY
, DAC.LAST_UPDATE_LOGIN
, DAC.LAST_UPDATED_BY
, DAC.LAST_UPDATE_DATE
, DAC.REQUEST_NAME
, DAC.REQUEST_MODE
, DAC.CLOSED_IND
, DAC.PURGABLE_IND
, DAC.WIF_IND
, DAC.WIF_PROGRAM_CODE
, DAC.WIF_PROGRAM_MOD_IND
, DAC.WIF_CATALOG_CAL_TYPE
, DAC.WIF_CATALOG_CI_SEQ_NUM
, DAC.WIF_CATALOG_MOD_IND
, DAC.SPECIAL_IND
, DAC.SPECIAL_PROGRAM_CODE
, DAC.SPECIAL_PROGRAM_MOD_IND
, DAC.SPECIAL_CATALOG
, DAC.SPECIAL_CATALOG_MOD_IND
, DAC.ENROLLED_IND
, DAC.SPA_COMPLETE_IND
, DAC.SUSA_COMPLETE_IND
, LK1.MEANING REQUEST_TYPE_MEANING
, LK2.MEANING REQUEST_MODE_MEANING
, DECODE(DAC.WIF_PROGRAM_CODE
, NULL
, NULL
, (SELECT PV1.TITLE
FROM IGS_PS_VER PV1
WHERE DAC.WIF_PROGRAM_CODE = PV1.COURSE_CD
AND ROWNUM < 2)) WIF_PROGRAM_CODE_MEANING
, (SELECT LK3.MEANING
FROM IGS_LOOKUP_VALUES LK3
WHERE LK3.LOOKUP_TYPE = 'IGS_DA_SPCL_PRGMS'
AND DAC.SPECIAL_PROGRAM_CODE = LK3.LOOKUP_CODE ) SPECIAL_PROGRAM_CODE_MEANING
, (SELECT LK4.MEANING
FROM IGS_LOOKUP_VALUES LK4
WHERE LK4.LOOKUP_TYPE = 'IGS_DA_SPCL_PRGM_CATS'
AND DAC.SPECIAL_CATALOG = LK4.LOOKUP_CODE ) SPECIAL_CATALOG_MEANING
, (SELECT CAI.DESCRIPTION
FROM IGS_CA_INST CAI
WHERE CAI.CAL_TYPE (+) = DAC.WIF_CATALOG_CAL_TYPE
AND CAI.SEQUENCE_NUMBER = DAC.WIF_CATALOG_CI_SEQ_NUM ) WIF_CATALOG_MEANING
FROM IGS_DA_CNFG_REQ_TYP DAC
, IGS_LOOKUP_VALUES LK1
, IGS_LOOKUP_VALUES LK2
WHERE LK1.LOOKUP_TYPE = 'IGS_DA_REQUEST_TYPE'
AND DAC.REQUEST_TYPE = LK1.LOOKUP_CODE
AND LK2.LOOKUP_TYPE = 'IGS_DA_SELECTION_MODE'
AND DAC.REQUEST_MODE = LK2.LOOKUP_CODE

Columns