Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Full View for Offer Conditions in the generic condition library |
Implementation/DBA Data: | Not implemented in this database |
SELECT CO.CONDITION_CATEGORY CONDITION_CATEGORY
, CO.CONDITION_NAME CONDITION_NAME
, CO.EFFECTIVE_FROM EFFECTIVE_FROM
, CO.EFFECTIVE_TO EFFECTIVE_TO
, CO.STATUS STATUS
, '_LA:CO.STATUS:IGS_LOOKUP_VALUES:IGS_UC_COND_STATUS:MEANING' "_LA:STATUS_DESC"
, CO.MARVIN_CODE MARVIN_CODE
, CO.SUMM_OF_COND SUMMARY_OF_CONDITIONS
, CO.LETTER_TEXT LETTER_TEXT
, CO.DECISION DECISION
, 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_OFFER_CONDS CO WITH READ ONLY