[Home] [Help]
View: IGF_AW_COA_RATE_MST_V
Product: | IGF - Financial Aid |
Description: | Cost of Attendance Rate Table Master |
Implementation/DBA Data: |
APPS.IGF_AW_COA_RATE_MST_V
|
View Text
SELECT RD.CI_CAL_TYPE
, RD.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, CA.START_DT
, CA.END_DT
, RD.ITEM_CODE
, IT.DESCRIPTION
FROM IGF_AW_COA_RATE_DET RD
, IGF_AW_ITEM IT
, IGS_CA_INST CA
WHERE RD.ITEM_CODE = IT.ITEM_CODE
AND CA.CAL_TYPE = RD.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = RD.CI_SEQUENCE_NUMBER GROUP BY RD.CI_CAL_TYPE
, RD.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, CA.START_DT
, CA.END_DT
, RD.ITEM_CODE
, IT.DESCRIPTION
Columns
Name |
CI_CAL_TYPE |
CI_SEQUENCE_NUMBER |
CI_ALTERNATE_CODE |
CI_START_DT |
CI_END_DT |
ITEM_CODE |
ITEM_DESCRIPTION |