[Home] [Help]
View: IGF_AW_COA_TERM_TOT_V
Product: | IGF - Financial Aid |
Description: | Stores cost of attendance amount split for a term |
Implementation/DBA Data: |
APPS.IGF_AW_COA_TERM_TOT_V
|
View Text
SELECT COAIT.BASE_ID
, COAIT.LD_CAL_TYPE
, COAIT.LD_SEQUENCE_NUMBER
, LOAD.ALTERNATE_CODE
, LOAD.START_DT
, LOAD.END_DT
, SUM (COAIT.AMOUNT) AMOUNT
FROM IGF_AW_COA_ITM_TERMS COAIT
, IGS_CA_INST LOAD
WHERE LOAD.CAL_TYPE = COAIT.LD_CAL_TYPE
AND LOAD.SEQUENCE_NUMBER = COAIT.LD_SEQUENCE_NUMBER GROUP BY COAIT.BASE_ID
, COAIT.LD_CAL_TYPE
, COAIT.LD_SEQUENCE_NUMBER
, LOAD.ALTERNATE_CODE
, LOAD.START_DT
, LOAD.END_DT
Columns
Name |
BASE_ID |
LD_CAL_TYPE |
LD_SEQUENCE_NUMBER |
LD_ALTERNATE_CODE |
LD_START_DT |
LD_END_DT |
AMOUNT |