Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_GR_ALT_COA_V |
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