VIEW: APPS.IGS_AD_OU_STAT_V

Source

View Text - Preformatted

SELECT AOS.ROWID ROW_ID, AOS.ADM_OUTCOME_STATUS ADM_OUTCOME_STATUS, AOS.DESCRIPTION DESCRIPTION, AOS.S_ADM_OUTCOME_STATUS S_ADM_OUTCOME_STATUS, AOS.SYSTEM_DEFAULT_IND SYSTEM_DEFAULT_IND, AOS.CLOSED_IND CLOSED_IND, AOS.CREATED_BY CREATED_BY , AOS.CREATION_DATE CREATION_DATE, AOS.LAST_UPDATED_BY LAST_UPDATED_BY, AOS.LAST_UPDATE_DATE LAST_UPDATE_DATE, AOS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LKUPV.MEANING MEANING, LKUPV.CLOSED_IND DSP_CLOSED_IND FROM IGS_AD_OU_STAT AOS, IGS_LOOKUPS_VIEW LKUPV WHERE AOS.S_ADM_OUTCOME_STATUS = LKUPV.LOOKUP_CODE AND LOOKUP_TYPE = 'ADM_OUTCOME_STATUS' AND( LKUPV.CLOSED_IND = 'N' OR AOS.S_ADM_OUTCOME_STATUS = LKUPV.LOOKUP_CODE)

View Text - HTML Formatted

SELECT AOS.ROWID ROW_ID
, AOS.ADM_OUTCOME_STATUS ADM_OUTCOME_STATUS
, AOS.DESCRIPTION DESCRIPTION
, AOS.S_ADM_OUTCOME_STATUS S_ADM_OUTCOME_STATUS
, AOS.SYSTEM_DEFAULT_IND SYSTEM_DEFAULT_IND
, AOS.CLOSED_IND CLOSED_IND
, AOS.CREATED_BY CREATED_BY
, AOS.CREATION_DATE CREATION_DATE
, AOS.LAST_UPDATED_BY LAST_UPDATED_BY
, AOS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AOS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LKUPV.MEANING MEANING
, LKUPV.CLOSED_IND DSP_CLOSED_IND
FROM IGS_AD_OU_STAT AOS
, IGS_LOOKUPS_VIEW LKUPV
WHERE AOS.S_ADM_OUTCOME_STATUS = LKUPV.LOOKUP_CODE
AND LOOKUP_TYPE = 'ADM_OUTCOME_STATUS' AND( LKUPV.CLOSED_IND = 'N' OR AOS.S_ADM_OUTCOME_STATUS = LKUPV.LOOKUP_CODE)