VIEW: APPS.IGF_GR_PELL_RNG_AMT_V

Source

View Text - Preformatted

SELECT CRNGD.ROWID ROW_ID, CI.ALTERNATE_CODE CI_ALTERNATE_CODE, CRNGD.ENROLLMENT_STAT ENROLLMENT_STAT, CRNGD.CI_CAL_TYPE CI_CAL_TYPE, CRNGD.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER, CI.START_DT CI_START_DT, CI.END_DT CI_END_DT, CRNGD.COA_START COA_START, CRNGD.COA_END COA_END, CRNGD.EFC_START EFC_START, CRNGD.EFC_END EFC_END, CRNGD.AMOUNT AMOUNT, CRNGD.CREATED_BY CREATED_BY, CRNGD.CREATION_DATE CREATION_DATE, CRNGD.LAST_UPDATED_BY LAST_UPDATED_BY, CRNGD.LAST_UPDATE_DATE LAST_UPDATE_DATE, CRNGD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGF_GR_PELL_RNG_AMT CRNGD, IGS_CA_INST CI WHERE CI.CAL_TYPE = CRNGD.CI_CAL_TYPE AND CI.SEQUENCE_NUMBER = CRNGD.CI_SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT CRNGD.ROWID ROW_ID
, CI.ALTERNATE_CODE CI_ALTERNATE_CODE
, CRNGD.ENROLLMENT_STAT ENROLLMENT_STAT
, CRNGD.CI_CAL_TYPE CI_CAL_TYPE
, CRNGD.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CI.START_DT CI_START_DT
, CI.END_DT CI_END_DT
, CRNGD.COA_START COA_START
, CRNGD.COA_END COA_END
, CRNGD.EFC_START EFC_START
, CRNGD.EFC_END EFC_END
, CRNGD.AMOUNT AMOUNT
, CRNGD.CREATED_BY CREATED_BY
, CRNGD.CREATION_DATE CREATION_DATE
, CRNGD.LAST_UPDATED_BY LAST_UPDATED_BY
, CRNGD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CRNGD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGF_GR_PELL_RNG_AMT CRNGD
, IGS_CA_INST CI
WHERE CI.CAL_TYPE = CRNGD.CI_CAL_TYPE
AND CI.SEQUENCE_NUMBER = CRNGD.CI_SEQUENCE_NUMBER