[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Full View for condition details that makes up the offer |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CO.CONDITION_CATEGORY CONDITION_CATEGORY
, CO.CONDITION_NAME CONDITION_NAME
, CO.CONDITION_LINE CONDITION_LINE
, CO.ABBREVIATION ABBREVIATION_CODE
, CO.GRADE_MARK GRADE_MARK
, CO.POINTS POINTS
, CO.SUBJECT SUBJECT_CODE
, CO.CONDITION_TEXT CONDITION_TEXT
, FT1.STATUS STATUS
, '_LA:FT1.STATUS:IGS_LOOKUP_VALUES:IGS_UC_COND_STATUS:MEANING' "_LA:STATUS_DESC"
, FT1.MARVIN_CODE MARVIN_CODE
, FT1.SUMM_OF_COND SUMMARY_OF_CONDITIONS
, FT1.DECISION DECISION
, FT2.ABBREV_TEXT ABBREVIATION_TEXT
, FT3.CODE_TEXT SUBJECT_TEXT
, CO.CREATED_BY CREATED_BY
, CO.CREATION_DATE CREATION_DATE
, CO.LAST_UPDATED_BY LAST_UPDATED_BY
, CO.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_COND_DETAILS CO
, IGS_UC_OFFER_CONDS FT1
, IGS_UC_REF_OFF_ABRV FT2
, IGS_UC_REF_CODES FT3
WHERE CO.CONDITION_CATEGORY = FT1.CONDITION_CATEGORY
AND CO.CONDITION_NAME = FT1.CONDITION_NAME
AND CO.ABBREVIATION = FT2.ABBREV_CODE (+)
AND CO.SUBJECT = FT3.CODE (+)
AND FT3.CODE_TYPE (+) = 'SB' WITH READ ONLY