View: IGF_AW_AWD_APT_V

Product:	IGF - Financial Aid
Description:	Award Periods Terms View
Implementation/DBA Data:	APPS.IGF_AW_AWD_APT_V

View Text

SELECT AP.ROWID
, AP.CI_CAL_TYPE
, AP.CI_SEQUENCE_NUMBER
, AY.ALTERNATE_CODE
, AY.START_DT
, AY.END_DT
, AP.AWARD_PRD_CD
, AP.AWARD_PRD_DESC
, AP.BBAY_FLAG
, APT.LD_CAL_TYPE
, APT.LD_SEQUENCE_NUMBER
, LD.ALTERNATE_CODE
, LD.START_DT
, LD.END_DT
, AP.CREATED_BY
, AP.CREATION_DATE
, AP.LAST_UPDATED_BY
, AP.LAST_UPDATE_DATE
, AP.LAST_UPDATE_LOGIN
FROM IGF_AW_AWARD_PRD AP
, IGF_AW_AWD_PRD_TERM APT
, IGS_CA_INST AY
, IGS_CA_INST LD
WHERE AP.CI_CAL_TYPE = APT.CI_CAL_TYPE
AND AP.CI_SEQUENCE_NUMBER = APT.CI_SEQUENCE_NUMBER
AND AP.AWARD_PRD_CD = APT.AWARD_PRD_CD
AND AP.CI_CAL_TYPE = AY.CAL_TYPE
AND AP.CI_SEQUENCE_NUMBER = AY.SEQUENCE_NUMBER
AND APT.LD_CAL_TYPE = LD.CAL_TYPE
AND APT.LD_SEQUENCE_NUMBER = LD.SEQUENCE_NUMBER

Columns