Product: | IGS - Student System |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGS_AD_OFRDFRMT_STAT_V |
SELECT AODS.ROWID ROW_ID
, AODS.ADM_OFFER_DFRMNT_STATUS ADM_OFFER_DFRMNT_STATUS
, AODS.DESCRIPTION DESCRIPTION
, AODS.S_ADM_OFFER_DFRMNT_STATUS S_ADM_OFFER_DFRMNT_STATUS
, LKUPV.MEANING MEANING
, LKUPV.CLOSED_IND DSP_CLOSED_IND
, AODS.SYSTEM_DEFAULT_IND SYSTEM_DEFAULT_IND
, AODS.CLOSED_IND CLOSED_IND
, AODS.CREATED_BY CREATED_BY
, AODS.CREATION_DATE CREATION_DATE
, AODS.LAST_UPDATED_BY LAST_UPDATED_BY
, AODS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AODS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_OFRDFRMT_STAT AODS
, IGS_LOOKUPS_VIEW LKUPV
WHERE LKUPV.LOOKUP_TYPE = 'ADM_OFFER_DFRMNT_STATUS'
AND LKUPV.LOOKUP_CODE = AODS.S_ADM_OFFER_DFRMNT_STATUS