VIEW: APPS.IGFBV_DL_YTD_DETAILS

Source

View Text - Preformatted

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, YTDD.BATCH_ID, YTDD.YTDD_ID, YTDD.CREATED_BY, YTDD.CREATION_DATE, YTDD.LAST_UPDATED_BY, YTDD.LAST_UPDATE_DATE, FABASE.PERSON_ID FROM IGF_DB_YTD_DTL_ALL YTDD, IGF_SL_LOANS_ALL LOANS, IGF_AW_AWARD_ALL AWD, IGF_AP_FA_BASE_REC_ALL FABASE WHERE YTDD.LOAN_NUMBER = LOANS.LOAN_NUMBER AND AWD.AWARD_ID = LOANS.AWARD_ID AND AWD.BASE_ID = FABASE.BASE_ID WITH READ ONLY

View Text - HTML Formatted

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
, YTDD.BATCH_ID
, YTDD.YTDD_ID
, YTDD.CREATED_BY
, YTDD.CREATION_DATE
, YTDD.LAST_UPDATED_BY
, YTDD.LAST_UPDATE_DATE
, FABASE.PERSON_ID
FROM IGF_DB_YTD_DTL_ALL YTDD
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWD
, IGF_AP_FA_BASE_REC_ALL FABASE
WHERE YTDD.LOAN_NUMBER = LOANS.LOAN_NUMBER
AND AWD.AWARD_ID = LOANS.AWARD_ID
AND AWD.BASE_ID = FABASE.BASE_ID WITH READ ONLY