Product: | IGF - Financial Aid |
---|---|
Description: | PLUS Loan Details View |
Implementation/DBA Data: | APPS.IGF_SL_PLUS_LOAN_DETAILS_V |
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'