VIEW: APPS.IGF_AP_ADM_SETUP_V

Source

View Text - Preformatted

SELECT admsetup.ROW_ID , admsetup.ADM_PROCESS_SEQ, admsetup.ADM_APPL_STAT , admappl.description, admsetup.ADM_OUTCOME_STAT , admout.description, admsetup.ADM_FEE_STAT , admfee.description, admsetup.ADM_OFFER_RESP_STAT, admresp.description, admsetup.CREATED_BY, admsetup.CREATION_DATE, admsetup.LAST_UPDATED_BY, admsetup.LAST_UPDATE_DATE, admsetup.LAST_UPDATE_LOGIN FROM IGF_AP_ADM_SETUP admsetup, IGS_AD_OU_STAT admout, IGS_AD_OFR_RESP_STAT admresp, IGS_AD_FEE_STAT admfee, IGS_AD_APPL_STAT admappl WHERE admsetup.ADM_APPL_STAT =admappl.ADM_APPL_STATUS(+) AND admsetup.ADM_OUTCOME_STAT=admout.ADM_OUTCOME_STATUS(+) AND admsetup.ADM_OFFER_RESP_STAT=admresp.ADM_OFFER_RESP_STATUS(+) AND admsetup.ADM_FEE_STAT= admfee.adm_fee_status(+)

View Text - HTML Formatted

SELECT ADMSETUP.ROW_ID
, ADMSETUP.ADM_PROCESS_SEQ
, ADMSETUP.ADM_APPL_STAT
, ADMAPPL.DESCRIPTION
, ADMSETUP.ADM_OUTCOME_STAT
, ADMOUT.DESCRIPTION
, ADMSETUP.ADM_FEE_STAT
, ADMFEE.DESCRIPTION
, ADMSETUP.ADM_OFFER_RESP_STAT
, ADMRESP.DESCRIPTION
, ADMSETUP.CREATED_BY
, ADMSETUP.CREATION_DATE
, ADMSETUP.LAST_UPDATED_BY
, ADMSETUP.LAST_UPDATE_DATE
, ADMSETUP.LAST_UPDATE_LOGIN
FROM IGF_AP_ADM_SETUP ADMSETUP
, IGS_AD_OU_STAT ADMOUT
, IGS_AD_OFR_RESP_STAT ADMRESP
, IGS_AD_FEE_STAT ADMFEE
, IGS_AD_APPL_STAT ADMAPPL
WHERE ADMSETUP.ADM_APPL_STAT =ADMAPPL.ADM_APPL_STATUS(+)
AND ADMSETUP.ADM_OUTCOME_STAT=ADMOUT.ADM_OUTCOME_STATUS(+)
AND ADMSETUP.ADM_OFFER_RESP_STAT=ADMRESP.ADM_OFFER_RESP_STATUS(+)
AND ADMSETUP.ADM_FEE_STAT= ADMFEE.ADM_FEE_STATUS(+)