eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGF_GR_ALT_COA_V

Product:	IGF - Financial Aid
Description:
Implementation/DBA Data:	APPS.IGF_GR_ALT_COA_V

View Text

SELECT ALTCOA.ROW_ID
, ALTCOA.ALTCOA_ID
, ALTCOA.ENRL_STAT
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_RFMS_ENROL_STAT'
, ALTCOA.ENRL_STAT)
, ALTCOA.CI_CAL_TYPE
, ALTCOA.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, ALTCOA.COA_END
, ALTCOA.COA_START
, ALTCOA.CREATED_BY
, ALTCOA.CREATION_DATE
, ALTCOA.LAST_UPDATED_BY
, ALTCOA. LAST_UPDATE_LOGIN
, ALTCOA. LAST_UPDATE_DATE
FROM IGF_GR_ALT_COA ALTCOA
, IGS_CA_INST CI
WHERE ALTCOA.CI_CAL_TYPE = CI.CAL_TYPE
AND ALTCOA.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

Columns

Name
ROW_ID
ALTCOA_ID
ENRL_STAT
ENRL_STAT_DESC
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
CI_ALTERNATE_CODE
CI_START_DT
CI_END_DT
COA_END
COA_START
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE