View: IGF_AW_COA_ITM_TERMS_V

Product:	IGF - Financial Aid
Description:	Stores amount split setup for a given cost of attendance item
Implementation/DBA Data:	APPS.IGF_AW_COA_ITM_TERMS_V

View Text

SELECT COAIT.ROWID
, COAIT.BASE_ID
, COAIT.ITEM_CODE
, AWITEM.DESCRIPTION
, COAIT.LD_CAL_TYPE
, COAIT.LD_SEQUENCE_NUMBER
, LOAD.ALTERNATE_CODE
, LOAD.START_DT
, LOAD.END_DT
, COAIT.AMOUNT
, COAIT.CREATED_BY
, COAIT.CREATION_DATE
, COAIT.LAST_UPDATED_BY
, COAIT.LAST_UPDATE_DATE
, COAIT.LAST_UPDATE_LOGIN
, COAIT.REQUEST_ID
, COAIT.PROGRAM_APPLICATION_ID
, COAIT.PROGRAM_ID
, COAIT.PROGRAM_UPDATE_DATE
, COAIT.LOCK_FLAG
FROM IGF_AW_COA_ITM_TERMS COAIT
, IGF_AW_ITEM AWITEM
, IGS_CA_INST LOAD
WHERE COAIT.ITEM_CODE = AWITEM.ITEM_CODE
AND LOAD.CAL_TYPE = COAIT.LD_CAL_TYPE
AND LOAD.SEQUENCE_NUMBER = COAIT.LD_SEQUENCE_NUMBER

Columns