VIEW: APPS.IGF_SL_PLUS_LOAN_DETAILS_V

Source

View Text - Preformatted

SELECT LOANS.ROW_ID, LOANS.LOAN_ID, LOANS.AWARD_ID, LOANS.SEQ_NUM, LOANS.LOAN_NUMBER, FMAST.FUND_CODE||TO_CHAR(LOANS.SEQ_NUM) LOAN_TYPE_NUM, LOANS.LOAN_PER_BEGIN_DATE, LOANS.LOAN_PER_END_DATE, LOANS.LOAN_STATUS, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_LOAN_STATUS', LOANS.LOAN_STATUS), LOANS.LOAN_STATUS_DATE, LOANS.LOAN_CHG_STATUS, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_LOAN_CHG_STATUS', LOANS.LOAN_CHG_STATUS), LOANS.LOAN_CHG_STATUS_DATE, LOANS.ACTIVE, LOANS.ACTIVE_DATE, LOANS.BORW_DETRM_CODE, LKV.MEANING BORROWER_DETRM_MEANING, LOANS.LEGACY_RECORD_FLAG, LOR.P_PERSON_ID, FABASE.PERSON_ID, FABASE.CI_CAL_TYPE, FABASE.CI_SEQUENCE_NUMBER, AWD.ACCEPTED_AMT, FCAT.FED_FUND_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_FED_FUND',FCAT.FED_FUND_CODE), CI.ALTERNATE_CODE, CI.START_DT, CI.END_DT, PERSON.PERSON_NUMBER, PERSON.FULL_NAME, LOANS.CREATED_BY, LOANS.CREATION_DATE, LOANS.LAST_UPDATED_BY, LOANS.LAST_UPDATE_DATE, LOANS.LAST_UPDATE_LOGIN, LOANS.REQUEST_ID, LOANS.PROGRAM_APPLICATION_ID, LOANS.PROGRAM_ID, LOANS.PROGRAM_UPDATE_DATE, LOANS.EXTERNAL_LOAN_ID_TXT FROM IGS_CA_INST CI, IGF_SL_LOANS LOANS, IGF_SL_LOR LOR, IGF_AW_AWARD AWD, IGF_AW_FUND_MAST FMAST, IGF_AW_FUND_CAT FCAT, IGF_AP_FA_BASE_REC FABASE, IGS_PE_PERSON_BASE_V PERSON, IGS_LOOKUP_VALUES LKV WHERE FABASE.CI_CAL_TYPE = CI.CAL_TYPE AND FABASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND FABASE.BASE_ID = AWD.BASE_ID AND AWD.FUND_ID = FMAST.FUND_ID AND FMAST.FUND_CODE = FCAT.FUND_CODE AND FCAT.FED_FUND_CODE IN ('DLP','FLP') AND LOANS.AWARD_ID = AWD.AWARD_ID AND LOR.P_PERSON_ID = PERSON.PERSON_ID AND LOANS.LOAN_ID = LOR.LOAN_ID AND LOANS.BORW_DETRM_CODE=LKV.LOOKUP_CODE(+) AND LKV.LOOKUP_TYPE(+)= 'IGS_FI_BORW_DETRM'

View Text - HTML Formatted

SELECT LOANS.ROW_ID
, LOANS.LOAN_ID
, LOANS.AWARD_ID
, LOANS.SEQ_NUM
, LOANS.LOAN_NUMBER
, FMAST.FUND_CODE||TO_CHAR(LOANS.SEQ_NUM) LOAN_TYPE_NUM
, LOANS.LOAN_PER_BEGIN_DATE
, LOANS.LOAN_PER_END_DATE
, LOANS.LOAN_STATUS
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_LOAN_STATUS'
, LOANS.LOAN_STATUS)
, LOANS.LOAN_STATUS_DATE
, LOANS.LOAN_CHG_STATUS
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_LOAN_CHG_STATUS'
, LOANS.LOAN_CHG_STATUS)
, LOANS.LOAN_CHG_STATUS_DATE
, LOANS.ACTIVE
, LOANS.ACTIVE_DATE
, LOANS.BORW_DETRM_CODE
, LKV.MEANING BORROWER_DETRM_MEANING
, LOANS.LEGACY_RECORD_FLAG
, LOR.P_PERSON_ID
, FABASE.PERSON_ID
, FABASE.CI_CAL_TYPE
, FABASE.CI_SEQUENCE_NUMBER
, AWD.ACCEPTED_AMT
, FCAT.FED_FUND_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_FED_FUND'
, FCAT.FED_FUND_CODE)
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, PERSON.PERSON_NUMBER
, PERSON.FULL_NAME
, LOANS.CREATED_BY
, LOANS.CREATION_DATE
, LOANS.LAST_UPDATED_BY
, LOANS.LAST_UPDATE_DATE
, LOANS.LAST_UPDATE_LOGIN
, LOANS.REQUEST_ID
, LOANS.PROGRAM_APPLICATION_ID
, LOANS.PROGRAM_ID
, LOANS.PROGRAM_UPDATE_DATE
, LOANS.EXTERNAL_LOAN_ID_TXT
FROM IGS_CA_INST CI
, IGF_SL_LOANS LOANS
, IGF_SL_LOR LOR
, IGF_AW_AWARD AWD
, IGF_AW_FUND_MAST FMAST
, IGF_AW_FUND_CAT FCAT
, IGF_AP_FA_BASE_REC FABASE
, IGS_PE_PERSON_BASE_V PERSON
, IGS_LOOKUP_VALUES LKV
WHERE FABASE.CI_CAL_TYPE = CI.CAL_TYPE
AND FABASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND FABASE.BASE_ID = AWD.BASE_ID
AND AWD.FUND_ID = FMAST.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND FCAT.FED_FUND_CODE IN ('DLP'
, 'FLP')
AND LOANS.AWARD_ID = AWD.AWARD_ID
AND LOR.P_PERSON_ID = PERSON.PERSON_ID
AND LOANS.LOAN_ID = LOR.LOAN_ID
AND LOANS.BORW_DETRM_CODE=LKV.LOOKUP_CODE(+)
AND LKV.LOOKUP_TYPE(+)= 'IGS_FI_BORW_DETRM'