View: IGF_AW_FUND_TP_V

Product:	IGF - Financial Aid
Description:	Lists of all the valid teaching periods during which this fund can be used
Implementation/DBA Data:	APPS.IGF_AW_FUND_TP_V

View Text

SELECT FTP.ROW_ID
, FTP.FUND_ID
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, FTP.TP_CAL_TYPE
, FTP.TP_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, FTP.TP_PERCT
, FTP.CREATED_BY
, FTP.CREATION_DATE
, FTP.LAST_UPDATE_DATE
, FTP.LAST_UPDATED_BY
, FTP.LAST_UPDATE_LOGIN
, FMAST.CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER
, AWD.ALTERNATE_CODE AWD_ALTERNATE_CODE
, AWD.START_DT AWD_START_DATE
, AWD.END_DT AWD_END_DATE
FROM IGF_AW_FUND_TP FTP
, IGS_CA_INST CI
, IGS_CA_INST AWD
, IGF_AW_FUND_MAST FMAST
WHERE FTP.TP_CAL_TYPE = CI.CAL_TYPE
AND FTP.TP_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND FTP.FUND_ID = FMAST.FUND_ID
AND FMAST.CI_CAL_TYPE = AWD.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = AWD.SEQUENCE_NUMBER

Columns