Product: | IGF - Financial Aid |
---|---|
Description: | Cost of Attendance Rate Table Detail |
Implementation/DBA Data: | APPS.IGF_AW_COA_RATE_DET_V |
SELECT RD.ROWID
, RD.CI_CAL_TYPE
, RD.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, RD.ITEM_CODE
, IT.DESCRIPTION
, RD.RATE_ORDER_NUM
, RD.PID_GROUP_CD
, RD.ORG_UNIT_CD
, RD.PROGRAM_TYPE
, RD.PROGRAM_LOCATION_CD
, RD.PROGRAM_CD
, RD.CLASS_STANDING
, RD.RESIDENCY_STATUS_CODE
, RD.HOUSING_STATUS_CODE
, RD.ATTENDANCE_TYPE
, RD.ATTENDANCE_MODE
, RD.LD_CAL_TYPE
, RD.LD_SEQUENCE_NUMBER
, CALD.ALTERNATE_CODE
, RD.MULT_FACTOR_CODE
, RD.MULT_AMOUNT_NUM
, RD.CREATED_BY
, RD.CREATION_DATE
, RD.LAST_UPDATED_BY
, RD.LAST_UPDATE_DATE
, RD.LAST_UPDATE_LOGIN
FROM IGF_AW_COA_RATE_DET RD
, IGF_AW_ITEM IT
, IGS_CA_INST CA
, IGS_CA_INST CALD
WHERE RD.ITEM_CODE = IT.ITEM_CODE
AND CA.CAL_TYPE = RD.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = RD.CI_SEQUENCE_NUMBER
AND CALD.CAL_TYPE(+) = RD.LD_CAL_TYPE
AND CALD.SEQUENCE_NUMBER(+) = RD.LD_SEQUENCE_NUMBER