View: IGF_AW_COA_LD_V

Product:	IGF - Financial Aid
Description:	Stores the relation between Cost of Attendance Code and Load Calendar
Implementation/DBA Data:	APPS.IGF_AW_COA_LD_V

View Text

SELECT COALD.ROW_ID
, COALD.COALD_ID
, COALD.COA_CODE
, COALD.CI_CAL_TYPE
, COALD.CI_SEQUENCE_NUMBER
, COALD.LD_CAL_TYPE
, COALD.LD_SEQUENCE_NUMBER
, LOAD.ALTERNATE_CODE
, LOAD.START_DT
, LOAD.END_DT
, COALD.LD_PERCT
, COALD.CREATED_BY
, COALD.CREATION_DATE
, COALD.LAST_UPDATED_BY
, COALD.LAST_UPDATE_DATE
, COALD.LAST_UPDATE_LOGIN
FROM IGF_AW_COA_LD COALD
, IGS_CA_INST LOAD
WHERE LOAD.CAL_TYPE = COALD.LD_CAL_TYPE
AND LOAD.SEQUENCE_NUMBER = COALD.LD_SEQUENCE_NUMBER

Columns