FND Design Data [Home] [Help]

View: IGF_AP_ADM_SETUP_V

Product: IGF - Financial Aid
Description: Obsolete
Implementation/DBA Data: ViewAPPS.IGF_AP_ADM_SETUP_V
View Text

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(+)

Columns

Name
ROW_ID
ADM_PROCESS_SEQ
ADM_APPL_STAT
ADM_APPL_STAT_DESC
ADM_OUTCOME_STAT
ADM_OUTCOME_STAT_DESC
ADM_FEE_STAT
ADM_FEE_STAT_DESC
ADM_OFFER_RESP_STAT
ADM_OFFER_RESP_STAT_DESC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN