Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds Year to Date Direct Loan Details |
Implementation/DBA Data: | APPS.IGFFV_DL_YTD_DETAILS |
SELECT YTDD.DL_VERSION
, YTDD.RECORD_TYPE
, YTDD.SCHOOL_CODE
, YTDD.REGION_CODE
, YTDD.STATE_CODE
, YTDD.REC_COUNT
, YTDD.STAT_END_DT
, YTDD.PROCESS_DT
, YTDD.LOAN_NUMBER
, YTDD.LOAN_BKD_DT
, YTDD.DISB_BKD_DT
, YTDD.DISB_GROSS
, YTDD.DISB_FEE
, YTDD.DISB_INT_REBATE
, YTDD.DISB_NET
, YTDD.DISB_NET_ADJ
, YTDD.DISB_NUM
, YTDD.DISB_SEQ_NUM
, YTDD.TRANS_TYPE
, YTDD.TRANS_DT
, YTDD.TOTAL_GROSS
, YTDD.TOTAL_FEE
, YTDD.TOTAL_INT_REBATE
, YTDD.TOTAL_NET
, FABASE.CI_CAL_TYPE
, FABASE.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, HZ.PARTY_NUMBER
, HZ.PERSON_FIRST_NAME
, HZ.PERSON_LAST_NAME
, HZ.PERSON_MIDDLE_NAME
, YTDD.BATCH_ID
, FABASE.BASE_ID
, FABASE.PERSON_ID
, YTDD.YTDD_ID
, YTDD.CREATED_BY
, YTDD.CREATION_DATE
, YTDD.LAST_UPDATED_BY
, YTDD.LAST_UPDATE_DATE
FROM IGF_DB_YTD_DTL_ALL YTDD
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWD
, IGF_AP_FA_BASE_REC_ALL FABASE
, HZ_PARTIES HZ
, IGS_CA_INST_ALL CA
WHERE YTDD.LOAN_NUMBER = LOANS.LOAN_NUMBER
AND AWD.AWARD_ID = LOANS.AWARD_ID
AND AWD.BASE_ID = FABASE.BASE_ID
AND HZ.PARTY_ID = FABASE.PERSON_ID
AND CA.CAL_TYPE = FABASE.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = FABASE.CI_SEQUENCE_NUMBER WITH READ ONLY