View: IGF_AW_AWD_AP_V

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

View Text

SELECT AP.CI_CAL_TYPE
, AP.CI_SEQUENCE_NUMBER
, AY.ALTERNATE_CODE
, AP.AWARD_PRD_CD
, AP.AWARD_PRD_DESC
, AP.BBAY_FLAG
, MIN(LD.START_DT) START_DT
, MAX(LD.END_DT) END_DT
, AP.INCLUDE_IN_SS_FLAG
, AP.DEFAULT_FLAG
FROM IGF_AW_AWARD_PRD AP
, IGS_CA_INST AY
, IGF_AW_AWD_PRD_TERM APT
, 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 GROUP BY AP.CI_CAL_TYPE
, AP.CI_SEQUENCE_NUMBER
, AY.ALTERNATE_CODE
, AP.AWARD_PRD_CD
, AP.AWARD_PRD_DESC
, AP.BBAY_FLAG
, AP.INCLUDE_IN_SS_FLAG
, AP.DEFAULT_FLAG

Columns