Product: | IGS - Student System |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGS_AD_UNIT_OU_STAT_V |
SELECT AUOS.ROWID ROW_ID
, AUOS.ADM_UNIT_OUTCOME_STATUS
, AUOS.DESCRIPTION
, AUOS.S_ADM_OUTCOME_STATUS
, AUOS.SYSTEM_DEFAULT_IND
, AUOS.CLOSED_IND
, AUOS.CREATED_BY
, AUOS.CREATION_DATE
, AUOS.LAST_UPDATED_BY
, AUOS.LAST_UPDATE_DATE
, AUOS.LAST_UPDATE_LOGIN
, LKUPV.MEANING MEANING
, LKUPV.UNIT_OUTCOME_IND DSP_UNIT_OUTCOME_IND
, LKUPV.CLOSED_IND DSP_CLOSED_IND
FROM IGS_AD_UNIT_OU_STAT AUOS
, IGS_LOOKUPS_VIEW LKUPV
WHERE AUOS.S_ADM_OUTCOME_STATUS = LKUPV.LOOKUP_CODE AND LOOKUP_TYPE = 'ADM_OUTCOME_STATUS'