View: IGF_AW_FSEOG_MATCH_V

Product:	IGF - Financial Aid
Description:	This entity is used to retrieve the Matching Fund and its Match Order for the specific Award Years
Implementation/DBA Data:	APPS.IGF_AW_FSEOG_MATCH_V

View Text

SELECT FMAT.ROWID
, FMAT.FUND_ID
, FMAST.DESCRIPTION
, FMAST.FUND_CODE
, FMAT.MATCH_ORDER
, FMAT.CI_CAL_TYPE
, FMAT.CI_SEQUENCE_NUMBER
, FMAST.MIN_AWARD_AMT
, FMAST.MAX_AWARD_AMT
, FMAT.CREATED_BY
, FMAT.CREATION_DATE
, FMAT.LAST_UPDATED_BY
, FMAT.LAST_UPDATE_DATE
, FMAT.LAST_UPDATE_LOGIN
FROM IGF_AW_FUND_MAST FMAST
, IGF_AW_FSEOG_MATCH FMAT
, IGF_AW_FUND_CAT FCAT
WHERE FMAST.FUND_ID = FMAT.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND FCAT.SYS_FUND_TYPE <> 'SPONSOR' ORDER BY FMAT.FUND_ID

Columns