View: IGFBV_DL_AWARD_DISBURSEMENTS

Product:	IGF - Financial Aid
Description:	Base view for the entity that holds Direct Loan Award Disbursements
Implementation/DBA Data:	APPS.IGFBV_DL_AWARD_DISBURSEMENTS

View Text

SELECT SDLC.DISB_GROSS_AMT
, SDLC.FEE_1
, SDLC.DISB_DATE
, SDLC.DISB_NET_AMT
, DDTL.DISB_ADJ_AMT
, '_LA:DDTL.DISB_STATUS:IGF_LOOKUPS_VIEW:IGF_DB_DL_DISB_STATUS:MEANING'
, DDTL.DISB_STATUS_DATE
, '_LA:DDTL.DISB_ACTIVITY:IGF_LOOKUPS_VIEW:IGF_DB_DL_ACTIVITY::MEANING'
, DDTL.DISB_BATCH_ID
, DDTL.DISB_ACK_DATE
, DDTL.BOOKING_BATCH_ID
, DDTL.BOOKED_DATE
, LOANS.LOAN_NUMBER
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, '_LA:DISB.TRANS_TYPE:IGF_LOOKUPS_VIEW:IGF_DB_TRANS_TYPE:MEANING'
, DISB.INT_REBATE_AMT
, '_LA:DISB.AFFIRM_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FABASE.CI_CAL_TYPE
, FABASE.CI_SEQUENCE_NUMBER
, LOANS.LOAN_ID
, FABASE.BASE_ID
, FABASE.PERSON_ID
, SDLC.AWARD_ID
, SDLC.DISB_NUM
, DDTL.DISB_SEQ_NUM
, SDLC.CREATED_BY
, SDLC.CREATION_DATE
, SDLC.LAST_UPDATED_BY
, SDLC.LAST_UPDATE_DATE
FROM IGF_SL_AWD_DISB_LOC_ALL SDLC
, IGF_AW_AWARD_ALL AWD
, IGF_AW_AWD_DISB_ALL DISB
, IGF_AW_FUND_MAST_ALL FMAST
, IGF_AW_FUND_CAT_ALL FCAT
, IGF_SL_LOANS_ALL LOANS
, IGF_AP_FA_BASE_REC_ALL FABASE
, IGF_DB_AWD_DISB_DTL_ALL DDTL
WHERE SDLC.AWARD_ID = AWD.AWARD_ID
AND SDLC.AWARD_ID = DISB.AWARD_ID
AND SDLC.DISB_NUM = DISB.DISB_NUM
AND DDTL.AWARD_ID = AWD.AWARD_ID
AND DDTL.DISB_NUM = DISB.DISB_NUM
AND FMAST.FUND_ID = AWD.FUND_ID
AND FCAT.FUND_CODE = FMAST.FUND_CODE
AND LOANS.AWARD_ID = AWD.AWARD_ID
AND FABASE.BASE_ID = AWD.BASE_ID
AND FCAT.FED_FUND_CODE IN ('DLP'
, 'DLS'
, 'DLU') WITH READ ONLY

Columns