VIEW: APPS.IGS_DA_CNFG_REQ_TYP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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