Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CC.ROWID ROW_ID
, L1.MEANING MEANING
, CC.CLASS CLASS
, CC.CODE_ID CODE_ID
, CC.NAME NAME
, CC.DESCRIPTION DESCRIPTION
, CC.CLOSED_IND CLOSED_IND
, CC.CREATED_BY
, CC.CREATION_DATE
, CC.LAST_UPDATED_BY
, CC.LAST_UPDATE_DATE
, CC.LAST_UPDATE_LOGIN
, CC.SYSTEM_STATUS
, DECODE(CC.SYSTEM_STATUS
, NULL
, NULL
, (SELECT L2.MEANING
FROM IGS_LOOKUP_VALUES L2
WHERE L2.LOOKUP_TYPE = CC.CLASS
AND L2.LOOKUP_CODE = CC.SYSTEM_STATUS))
, CC.SYSTEM_DEFAULT
, CC.CLASS_TYPE_CODE
FROM IGS_AD_CODE_CLASSES CC
, IGS_LOOKUP_VALUES L1
WHERE L1.LOOKUP_TYPE IN ('ADM_CODE_CLASSES'
, 'IGS_AD_QUAL_TYPE')
AND L1.LOOKUP_CODE = CC.CLASS