Product: | IGF - Financial Aid |
---|---|
Description: | FORM VIEW formed by joining IGF_AW_AWARD MO view, IGF_AW_FUND_TP MO view, IGF_AW_FUND_MAST MO View, IGF_AW_FUND_CAT MO View and IGS_CA_INST. The view holds students award details for a sponsor fund |
Implementation/DBA Data: | APPS.IGF_SP_AWARD_V |
SELECT DISTINCT AWD.ROW_ID
, AWD.AWARD_ID
, FMAST.CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER
, ADISB.LD_CAL_TYPE
, ADISB.LD_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, FMAST.FUND_CODE
, FCAT.FED_FUND_CODE
, FCAT.SYS_FUND_TYPE
, AWD.FUND_ID
, FMAST.DESCRIPTION
, AWD.BASE_ID
, AWD.ACCEPTED_AMT
, AWD.PAID_AMT
, AWD.MANUAL_UPDATE
, AWD.AWARD_DATE
, AWD.AWARD_STATUS
, AWD.CREATED_BY
, AWD.CREATION_DATE
, AWD.LAST_UPDATED_BY
, AWD.LAST_UPDATE_DATE
, AWD.LAST_UPDATE_LOGIN
, AWD.PROGRAM_APPLICATION_ID
, AWD.PROGRAM_ID
, AWD.PROGRAM_UPDATE_DATE
, AWD.REQUEST_ID
FROM IGF_AW_AWD_DISB ADISB
, IGF_AW_AWARD AWD
, IGF_AW_FUND_MAST FMAST
, IGF_AW_FUND_CAT FCAT
, IGS_CA_INST CI
WHERE ADISB.AWARD_ID = AWD.AWARD_ID
AND AWD.FUND_ID = FMAST.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND ADISB.LD_CAL_TYPE = CI.CAL_TYPE
AND ADISB.LD_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER