VIEW: APPS.IGF_AW_LOAN_LIMIT_V

Source

View Text - Preformatted

SELECT ALLT.ROW_ID, ALLT.ALLT_ID, ALLT.CI_CAL_TYPE, ALLT.CI_SEQUENCE_NUMBER, CI.ALTERNATE_CODE, CI.START_DT, CI.END_DT, ALLT.FFELP_GRADE_LEVEL, ALLT.DL_GRADE_LEVEL, ALLT.DEPEND_STAT, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_DEP_STATUS' ,ALLT.DEPEND_STAT), ALLT.SUBS_ANNUAL_LT, ALLT.TOT_ANNUAL_LT, ALLT.SUBS_AGGR_LT, ALLT.TOT_AGGR_LT, ALLT.CREATED_BY, ALLT.CREATION_DATE, ALLT.LAST_UPDATED_BY, ALLT.LAST_UPDATE_DATE, ALLT.LAST_UPDATE_LOGIN, ALLT.TOT_ANNUAL_LT - ALLT.SUBS_ANNUAL_LT FROM IGF_AW_LOAN_LIMIT ALLT, IGS_CA_INST CI WHERE CI.CAL_TYPE = ALLT.CI_CAL_TYPE and CI.SEQUENCE_NUMBER = ALLT.CI_SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT ALLT.ROW_ID
, ALLT.ALLT_ID
, ALLT.CI_CAL_TYPE
, ALLT.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, ALLT.FFELP_GRADE_LEVEL
, ALLT.DL_GRADE_LEVEL
, ALLT.DEPEND_STAT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_DEP_STATUS'
, ALLT.DEPEND_STAT)
, ALLT.SUBS_ANNUAL_LT
, ALLT.TOT_ANNUAL_LT
, ALLT.SUBS_AGGR_LT
, ALLT.TOT_AGGR_LT
, ALLT.CREATED_BY
, ALLT.CREATION_DATE
, ALLT.LAST_UPDATED_BY
, ALLT.LAST_UPDATE_DATE
, ALLT.LAST_UPDATE_LOGIN
, ALLT.TOT_ANNUAL_LT - ALLT.SUBS_ANNUAL_LT
FROM IGF_AW_LOAN_LIMIT ALLT
, IGS_CA_INST CI
WHERE CI.CAL_TYPE = ALLT.CI_CAL_TYPE
AND CI.SEQUENCE_NUMBER = ALLT.CI_SEQUENCE_NUMBER