[Home] [Help]
View: IGF_AW_AWD_LD_CAL_V
Product: | IGF - Financial Aid |
Description: | Retrieves all the load calendars that fall within an award year |
Implementation/DBA Data: |
APPS.IGF_AW_AWD_LD_CAL_V
|
View Text
SELECT AW.ROW_ID
, AW.CAL_TYPE
, AW.SEQUENCE_NUMBER
, AW.ALTERNATE_CODE
, AW.START_DT
, AW.END_DT
, LD.CAL_TYPE
, LD.SEQUENCE_NUMBER
, LD.ALTERNATE_CODE
, LD.START_DT
, LD.END_DT
FROM IGS_CA_INST AW
, IGS_CA_INST LD
, IGS_CA_TYPE LD_T
, IGS_CA_TYPE AW_T
, IGS_CA_INST_REL REL
WHERE REL.SUP_CAL_TYPE=AW.CAL_TYPE
AND REL.SUP_CI_SEQUENCE_NUMBER=AW.SEQUENCE_NUMBER
AND REL.SUB_CAL_TYPE=LD.CAL_TYPE
AND REL.SUB_CI_SEQUENCE_NUMBER=LD.SEQUENCE_NUMBER
AND AW.CAL_TYPE = AW_T.CAL_TYPE
AND AW_T.S_CAL_CAT='AWARD'
AND LD.CAL_TYPE = LD_T.CAL_TYPE
AND LD_T.S_CAL_CAT='LOAD'
Columns
Name |
ROW_ID |
AW_CAL_TYPE |
AW_SEQUENCE_NUMBER |
AW_ALTERNATE_CODE |
AW_START_DT |
AW_END_DT |
LD_CAL_TYPE |
LD_SEQUENCE_NUMBER |
LD_ALTERNATE_CODE |
LD_START_DT |
LD_END_DT |