VIEW: APPS.IGS_UC_MAP_OUT_STAT_V

Source

View Text - Preformatted

SELECT mou.rowid ROW_ID, mou.System_code System_code, mou.Decision_code Decision_code, Lk1.meaning Decision_Desc, ou.s_adm_outcome_status System_outcome_status, Lk2.meaning Sys_outcome_status_desc , mou.Adm_outcome_status Adm_outcome_status, ou.description Adm_outcome_status_desc, mou.Default_ind Default_ind, mou.Closed_ind Closed_ind, mou.CREATED_BY ,mou.CREATION_DATE ,mou.LAST_UPDATED_BY ,mou.LAST_UPDATE_DATE ,mou.LAST_UPDATE_LOGIN FROM IGS_UC_MAP_OUT_STAT mou , IGS_LOOKUPS_VIEW lk1 , IGS_AD_OU_STAT ou , IGS_LOOKUPS_VIEW lk2 WHERE lk1.lookup_type = 'IGS_UC_APP_DECISION' AND lk1.lookup_code= mou.decision_code AND lk1.closed_ind ='N' AND ou.adm_outcome_status = mou.adm_outcome_status AND ou.closed_ind ='N' AND Lk2.lookup_type = 'ADM_OUTCOME_STATUS' AND lk2.lookup_code = ou.s_adm_outcome_status AND lk2.closed_ind = 'N'

View Text - HTML Formatted

SELECT MOU.ROWID ROW_ID
, MOU.SYSTEM_CODE SYSTEM_CODE
, MOU.DECISION_CODE DECISION_CODE
, LK1.MEANING DECISION_DESC
, OU.S_ADM_OUTCOME_STATUS SYSTEM_OUTCOME_STATUS
, LK2.MEANING SYS_OUTCOME_STATUS_DESC
, MOU.ADM_OUTCOME_STATUS ADM_OUTCOME_STATUS
, OU.DESCRIPTION ADM_OUTCOME_STATUS_DESC
, MOU.DEFAULT_IND DEFAULT_IND
, MOU.CLOSED_IND CLOSED_IND
, MOU.CREATED_BY
, MOU.CREATION_DATE
, MOU.LAST_UPDATED_BY
, MOU.LAST_UPDATE_DATE
, MOU.LAST_UPDATE_LOGIN
FROM IGS_UC_MAP_OUT_STAT MOU
, IGS_LOOKUPS_VIEW LK1
, IGS_AD_OU_STAT OU
, IGS_LOOKUPS_VIEW LK2
WHERE LK1.LOOKUP_TYPE = 'IGS_UC_APP_DECISION'
AND LK1.LOOKUP_CODE= MOU.DECISION_CODE
AND LK1.CLOSED_IND ='N'
AND OU.ADM_OUTCOME_STATUS = MOU.ADM_OUTCOME_STATUS
AND OU.CLOSED_IND ='N'
AND LK2.LOOKUP_TYPE = 'ADM_OUTCOME_STATUS'
AND LK2.LOOKUP_CODE = OU.S_ADM_OUTCOME_STATUS
AND LK2.CLOSED_IND = 'N'