Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT ACOS.ROWID ROW_ID
, ACOS.ADM_CNDTNL_OFFER_STATUS ADM_CNDTNL_OFFER_STATUS
, ACOS.DESCRIPTION DESCRIPTION
, ACOS.S_ADM_CNDTNL_OFFER_STATUS S_ADM_CNDTNL_OFFER_STATUS
, ACOS.SYSTEM_DEFAULT_IND SYSTEM_DEFAULT_IND
, ACOS.CLOSED_IND CLOSED_IND
, LKUP.MEANING MEANING
, LKUP.CLOSED_IND DSP_CLOSED_IND
, ACOS.CREATED_BY CREATED_BY
, ACOS.CREATION_DATE CREATION_DATE
, ACOS.LAST_UPDATED_BY LAST_UPDATED_BY
, ACOS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ACOS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_CNDNL_OFRSTAT ACOS
, IGS_LOOKUPS_VIEW LKUP
WHERE LKUP.LOOKUP_TYPE = 'ADM_CNDTNL_OFFER_STATUS'
AND LKUP.LOOKUP_CODE = ACOS.S_ADM_CNDTNL_OFFER_STATUS