VIEW: APPS.IGSFV_UC_CONDITION_DETAILS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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