VIEW: APPS.IGS_UC_COND_DETAILS_V

Source

View Text - Preformatted

SELECT cond.ROWID ROW_ID, cond.CONDITION_CATEGORY CONDITION_CATEGORY, cond.CONDITION_NAME CONDITION_NAME, cond.CONDITION_LINE CONDITION_LINE, cond.ABBREVIATION ABBREVIATION, (select abbrev_text from IGS_UC_REF_OFF_ABRV where abbrev_code = cond.ABBREVIATION) ABBREV_DESC, cond.GRADE_MARK GRADE_MARK, cond.POINTS POINTS, cond.SUBJECT SUBJECT, (SELECT CODE_TEXT FROM IGS_UC_REF_CODES WHERE code_type = 'SB' and code = cond.SUBJECT) SUBJECT_DESC, cond.CONDITION_TEXT CONDITION_TEXT, cond.CREATED_BY CREATED_BY, cond.CREATION_DATE CREATION_DATE, cond.LAST_UPDATED_BY LAST_UPDATED_BY, cond.LAST_UPDATE_DATE LAST_UPDATE_DATE, cond.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_UC_COND_DETAILS cond

View Text - HTML Formatted

SELECT COND.ROWID ROW_ID
, COND.CONDITION_CATEGORY CONDITION_CATEGORY
, COND.CONDITION_NAME CONDITION_NAME
, COND.CONDITION_LINE CONDITION_LINE
, COND.ABBREVIATION ABBREVIATION
, (SELECT ABBREV_TEXT
FROM IGS_UC_REF_OFF_ABRV
WHERE ABBREV_CODE = COND.ABBREVIATION) ABBREV_DESC
, COND.GRADE_MARK GRADE_MARK
, COND.POINTS POINTS
, COND.SUBJECT SUBJECT
, (SELECT CODE_TEXT
FROM IGS_UC_REF_CODES
WHERE CODE_TYPE = 'SB'
AND CODE = COND.SUBJECT) SUBJECT_DESC
, COND.CONDITION_TEXT CONDITION_TEXT
, COND.CREATED_BY CREATED_BY
, COND.CREATION_DATE CREATION_DATE
, COND.LAST_UPDATED_BY LAST_UPDATED_BY
, COND.LAST_UPDATE_DATE LAST_UPDATE_DATE
, COND.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_UC_COND_DETAILS COND