Product: | IGF - Financial Aid |
---|---|
Description: | FORM VIEW formed by joining IGF_SP_STDNT_REL MO view, IGF_AW_FUND_MAST view and IGF_AP_FA_BASE_REC. The view holds sponsor student relation details |
Implementation/DBA Data: | APPS.IGF_SP_STDNT_REL_V |
SELECT SPSTD.ROWID
, SPSTD.SPNSR_STDNT_ID
, SPSTD.FUND_ID
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, FMAST.DISCONTINUE_FUND
, SPSTD.BASE_ID
, SPSTD.PERSON_ID
, PPB.PERSON_NUMBER
, PPB.FULL_NAME
, SPSTD.LD_CAL_TYPE
, SPSTD.LD_SEQUENCE_NUMBER
, SPSTD.TOT_SPNSR_AMOUNT
, SPSTD.MIN_CREDIT_POINTS
, SPSTD.MIN_ATTENDANCE_TYPE
, AT.DESCRIPTION
, SPSTD.CREATED_BY
, SPSTD.CREATION_DATE
, SPSTD.LAST_UPDATED_BY
, SPSTD.LAST_UPDATE_DATE
, SPSTD.LAST_UPDATE_LOGIN
, SPSTD.ORG_ID
FROM IGF_SP_STDNT_REL SPSTD
, IGF_AW_FUND_MAST FMAST
, IGF_AP_FA_BASE_REC FA_DETAIL
, IGS_PE_PERSON_BASE_V PPB
, IGS_CA_INST CI
, IGS_EN_ATD_TYPE AT
WHERE SPSTD.FUND_ID = FMAST.FUND_ID
AND SPSTD.BASE_ID = FA_DETAIL.BASE_ID
AND SPSTD.PERSON_ID = PPB.PERSON_ID
AND SPSTD.LD_CAL_TYPE = CI.CAL_TYPE
AND SPSTD.LD_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SPSTD.MIN_ATTENDANCE_TYPE = AT.ATTENDANCE_TYPE(+)