VIEW: APPS.IGF_DB_DL_DISB_DTL_V

Source

View Text - Preformatted

SELECT ddtl.row_id ROW_ID, ddtl.award_id AWARD_ID, ddtl.disb_num DISB_NUM, ddtl.disb_seq_num DISB_SEQ_NUM, ddtl.disb_activity DISB_ACTIVITY, ddtl.disb_gross_amt DISB_GROSS_AMT, ddtl.fee_1 FEE_1, ddtl.fee_2 FEE_2, ddtl.disb_net_amt DISB_NET_AMT, ddtl.disb_adj_amt DISB_ADJ_AMT, ddtl.fee_paid_1 FEE_PAID_1, ddtl.fee_paid_2 FEE_PAID_2, ddtl.disb_date DISB_DATE, ddtl.disb_batch_id DISB_BATCH_ID, ddtl.disb_ack_date DISB_ACK_DATE, ddtl.booking_batch_id BOOKING_BATCH_ID, ddtl.booked_date BOOKED_DATE, ddtl.disb_status DISB_STATUS, ddtl.disb_status_date DISB_STATUS_DATE, ddtl.sf_status SF_STATUS, ddtl.sf_status_date SF_STATUS_DATE, ddtl.sf_invoice_num SF_INVOICE_NUM, lar.loan_number LOAN_NUMBER, adisb.affirm_flag AFFIRM_FLAG, adisb.created_by CREATED_BY, adisb.creation_date CREATION_DATE, adisb.last_updated_by LAST_UPDATED_BY, adisb.last_update_date LAST_UPDATE_DATE, adisb.last_update_login LAST_UPDATE_LOGIN, adisb.request_id REQUEST_ID, adisb.program_application_id PROGRAM_APPLICATION_ID, adisb.program_id PROGRAM_ID, adisb.program_update_date PROGRAM_UPDATE_DATE, adisb.int_rebate_amt FROM igf_db_awd_disb_dtl ddtl, igf_aw_awd_disb adisb, igf_aw_award awd, igf_sl_loans lar, igf_lookups_view lkps, igf_aw_fund_mast fmast, igf_aw_fund_cat fcat WHERE ddtl.award_id = adisb.award_id AND ddtl.disb_num = adisb.disb_num AND ddtl.award_id = awd.award_id AND ddtl.award_id = lar.award_id AND awd.fund_id = fmast.fund_id AND fmast.fund_code = fcat.fund_code AND lkps.lookup_type in ('IGF_SL_DL_STAFFORD','IGF_SL_DL_PLUS') AND fcat.fed_fund_code = lkps.lookup_code

View Text - HTML Formatted

SELECT DDTL.ROW_ID ROW_ID
, DDTL.AWARD_ID AWARD_ID
, DDTL.DISB_NUM DISB_NUM
, DDTL.DISB_SEQ_NUM DISB_SEQ_NUM
, DDTL.DISB_ACTIVITY DISB_ACTIVITY
, DDTL.DISB_GROSS_AMT DISB_GROSS_AMT
, DDTL.FEE_1 FEE_1
, DDTL.FEE_2 FEE_2
, DDTL.DISB_NET_AMT DISB_NET_AMT
, DDTL.DISB_ADJ_AMT DISB_ADJ_AMT
, DDTL.FEE_PAID_1 FEE_PAID_1
, DDTL.FEE_PAID_2 FEE_PAID_2
, DDTL.DISB_DATE DISB_DATE
, DDTL.DISB_BATCH_ID DISB_BATCH_ID
, DDTL.DISB_ACK_DATE DISB_ACK_DATE
, DDTL.BOOKING_BATCH_ID BOOKING_BATCH_ID
, DDTL.BOOKED_DATE BOOKED_DATE
, DDTL.DISB_STATUS DISB_STATUS
, DDTL.DISB_STATUS_DATE DISB_STATUS_DATE
, DDTL.SF_STATUS SF_STATUS
, DDTL.SF_STATUS_DATE SF_STATUS_DATE
, DDTL.SF_INVOICE_NUM SF_INVOICE_NUM
, LAR.LOAN_NUMBER LOAN_NUMBER
, ADISB.AFFIRM_FLAG AFFIRM_FLAG
, ADISB.CREATED_BY CREATED_BY
, ADISB.CREATION_DATE CREATION_DATE
, ADISB.LAST_UPDATED_BY LAST_UPDATED_BY
, ADISB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADISB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADISB.REQUEST_ID REQUEST_ID
, ADISB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ADISB.PROGRAM_ID PROGRAM_ID
, ADISB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ADISB.INT_REBATE_AMT
FROM IGF_DB_AWD_DISB_DTL DDTL
, IGF_AW_AWD_DISB ADISB
, IGF_AW_AWARD AWD
, IGF_SL_LOANS LAR
, IGF_LOOKUPS_VIEW LKPS
, IGF_AW_FUND_MAST FMAST
, IGF_AW_FUND_CAT FCAT
WHERE DDTL.AWARD_ID = ADISB.AWARD_ID
AND DDTL.DISB_NUM = ADISB.DISB_NUM
AND DDTL.AWARD_ID = AWD.AWARD_ID
AND DDTL.AWARD_ID = LAR.AWARD_ID
AND AWD.FUND_ID = FMAST.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND LKPS.LOOKUP_TYPE IN ('IGF_SL_DL_STAFFORD'
, 'IGF_SL_DL_PLUS')
AND FCAT.FED_FUND_CODE = LKPS.LOOKUP_CODE