VIEW: APPS.IGF_SL_LOANS_SUM_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)