Product: | IGF - Financial Aid |
---|---|
Description: | Loans Summary View |
Implementation/DBA Data: | APPS.IGF_SL_LOANS_SUM_V |
SELECT LOANS.ROW_ID
, LOANS.LOAN_ID
, LOANS.AWARD_ID
, LOANS.SEQ_NUM
, LOR.ORIG_BATCH_ID
, LOANS.LOAN_NUMBER
, 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.ACTIVE
, LOANS.ACTIVE_DATE
, AWD.ACCEPTED_AMT
, AWD.PAID_AMT
, FABASE.BASE_ID
, FABASE.CI_CAL_TYPE
, FABASE.CI_SEQUENCE_NUMBER
, FABASE.PERSON_ID
, S_PERSON.PERSON_NUMBER
, S_PERSON.FULL_NAME
, LOR.P_PERSON_ID
, P_PERSON.PERSON_NUMBER
, P_PERSON.FULL_NAME
FROM IGF_SL_LOANS LOANS
, IGF_SL_LOR LOR
, IGF_AW_AWARD AWD
, IGF_AP_FA_BASE_REC FABASE
, IGS_PE_PERSON_BASE_V P_PERSON
, IGS_PE_PERSON_BASE_V S_PERSON
WHERE FABASE.BASE_ID = AWD.BASE_ID
AND LOANS.AWARD_ID = AWD.AWARD_ID
AND FABASE.PERSON_ID = S_PERSON.PERSON_ID
AND LOANS.LOAN_ID = LOR.LOAN_ID
AND LOR.P_PERSON_ID = P_PERSON.PERSON_ID (+)