VIEW: APPS.IGF_SE_AWD_DISB_V

Source

View Text - Preformatted

SELECT ADISB.ROWID, ADISB.AWARD_ID, ADISB.DISB_NUM, ADISB.TP_CAL_TYPE, ADISB.TP_SEQUENCE_NUMBER, ADISB.DISB_GROSS_AMT, ADISB.FEE_1, ADISB.FEE_2, ADISB.DISB_NET_AMT, ADISB.DISB_DATE, ADISB.TRANS_TYPE, ADISB.ELIG_STATUS, ADISB.ELIG_STATUS_DATE, ADISB.AFFIRM_FLAG, ADISB.HOLD_REL_IND, ADISB.MANUAL_HOLD_IND, ADISB.DISB_STATUS, ADISB.DISB_STATUS_DATE, ADISB.LATE_DISB_IND, ADISB.FUND_DIST_MTHD, ADISB.PREV_REPORTED_IND, ADISB.FUND_RELEASE_DATE, ADISB.FUND_STATUS, ADISB.FUND_STATUS_DATE, ADISB.FEE_PAID_1, ADISB.FEE_PAID_2, ADISB.CHEQUE_NUMBER, ADISB.CREATED_BY, ADISB.CREATION_DATE, ADISB.LAST_UPDATED_BY, ADISB.LAST_UPDATE_DATE, ADISB.LAST_UPDATE_LOGIN, ADISB.REQUEST_ID, ADISB.PROGRAM_APPLICATION_ID, ADISB.PROGRAM_ID, ADISB.PROGRAM_UPDATE_DATE, ADISB.ORG_ID, ADISB.LD_CAL_TYPE, ADISB.LD_SEQUENCE_NUMBER, ADISB.DISB_ACCEPTED_AMT, ADISB.DISB_PAID_AMT, ADISB.RVSN_ID, ADISB.INT_REBATE_AMT, ADISB.FORCE_DISB, ADISB.MIN_CREDIT_PTS, ADISB.DISB_EXP_DT, ADISB.VERF_ENFR_DT, NULL, NULL, NULL, NULL, ADISB.FEE_CLASS, ADISB.SHOW_ON_BILL, (NVL(ADISB.DISB_ACCEPTED_AMT,0) - NVL(ADISB.DISB_PAID_AMT,0)) REMAINING_AMOUNT, DECODE( NVL(ADISB.DISB_ACCEPTED_AMT,0), 0, 0, ROUND(NVL(ADISB.DISB_PAID_AMT,0) * 100/ ADISB.DISB_ACCEPTED_AMT)) PROGRESS_TWDS_LMT, CILD.ALTERNATE_CODE ld_alternate_code FROM IGF_AW_AWD_DISB_ALL ADISB, IGS_CA_INST CILD WHERE CILD.CAL_TYPE = ADISB.LD_CAL_TYPE AND CILD.SEQUENCE_NUMBER = ADISB.LD_SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT ADISB.ROWID
, ADISB.AWARD_ID
, ADISB.DISB_NUM
, ADISB.TP_CAL_TYPE
, ADISB.TP_SEQUENCE_NUMBER
, ADISB.DISB_GROSS_AMT
, ADISB.FEE_1
, ADISB.FEE_2
, ADISB.DISB_NET_AMT
, ADISB.DISB_DATE
, ADISB.TRANS_TYPE
, ADISB.ELIG_STATUS
, ADISB.ELIG_STATUS_DATE
, ADISB.AFFIRM_FLAG
, ADISB.HOLD_REL_IND
, ADISB.MANUAL_HOLD_IND
, ADISB.DISB_STATUS
, ADISB.DISB_STATUS_DATE
, ADISB.LATE_DISB_IND
, ADISB.FUND_DIST_MTHD
, ADISB.PREV_REPORTED_IND
, ADISB.FUND_RELEASE_DATE
, ADISB.FUND_STATUS
, ADISB.FUND_STATUS_DATE
, ADISB.FEE_PAID_1
, ADISB.FEE_PAID_2
, ADISB.CHEQUE_NUMBER
, ADISB.CREATED_BY
, ADISB.CREATION_DATE
, ADISB.LAST_UPDATED_BY
, ADISB.LAST_UPDATE_DATE
, ADISB.LAST_UPDATE_LOGIN
, ADISB.REQUEST_ID
, ADISB.PROGRAM_APPLICATION_ID
, ADISB.PROGRAM_ID
, ADISB.PROGRAM_UPDATE_DATE
, ADISB.ORG_ID
, ADISB.LD_CAL_TYPE
, ADISB.LD_SEQUENCE_NUMBER
, ADISB.DISB_ACCEPTED_AMT
, ADISB.DISB_PAID_AMT
, ADISB.RVSN_ID
, ADISB.INT_REBATE_AMT
, ADISB.FORCE_DISB
, ADISB.MIN_CREDIT_PTS
, ADISB.DISB_EXP_DT
, ADISB.VERF_ENFR_DT
, NULL
, NULL
, NULL
, NULL
, ADISB.FEE_CLASS
, ADISB.SHOW_ON_BILL
, (NVL(ADISB.DISB_ACCEPTED_AMT
, 0) - NVL(ADISB.DISB_PAID_AMT
, 0)) REMAINING_AMOUNT
, DECODE( NVL(ADISB.DISB_ACCEPTED_AMT
, 0)
, 0
, 0
, ROUND(NVL(ADISB.DISB_PAID_AMT
, 0) * 100/ ADISB.DISB_ACCEPTED_AMT)) PROGRESS_TWDS_LMT
, CILD.ALTERNATE_CODE LD_ALTERNATE_CODE
FROM IGF_AW_AWD_DISB_ALL ADISB
, IGS_CA_INST CILD
WHERE CILD.CAL_TYPE = ADISB.LD_CAL_TYPE
AND CILD.SEQUENCE_NUMBER = ADISB.LD_SEQUENCE_NUMBER