VIEW: APPS.IGF_DB_AWD_DISB_DTL_V

Source

View Text - Preformatted

SELECT DDTLV.ROW_ID, DDTLV.AWARD_ID, DDTLV.DISB_NUM, DDTLV.DISB_SEQ_NUM, DDTLV.DISB_GROSS_AMT, DDTLV.FEE_1, DDTLV.FEE_2, DDTLV.DISB_NET_AMT, DDTLV.DISB_ADJ_AMT, DDTLV.DISB_DATE, DDTLV.FEE_PAID_1, DDTLV.FEE_PAID_2, DDTLV.DISB_ACTIVITY, NULL, NULL, NULL, NULL, NULL, NULL, DDTLV.SF_STATUS, DDTLV.SF_STATUS_DATE, DDTLV.SF_INVOICE_NUM, DDTLV.SPNSR_CREDIT_ID, DDTLV.SPNSR_CHARGE_ID, DDTLV.SF_CREDIT_ID, DDTLV.ERROR_DESC, DDTLV.CREATED_BY, DDTLV.CREATION_DATE, DDTLV.LAST_UPDATED_BY, DDTLV.LAST_UPDATE_DATE, DDTLV.LAST_UPDATE_LOGIN, DDTLV.REQUEST_ID, DDTLV.PROGRAM_APPLICATION_ID, DDTLV.PROGRAM_ID, DDTLV.PROGRAM_UPDATE_DATE, DDTLV.NOTIFICATION_DATE, igf_aw_gen.lookup_desc('IGF_DB_DL_DISB_STATUS',DDTLV.DISB_STATUS), igf_aw_gen.lookup_desc('IGF_DB_DL_ACTIVITY',DDTLV.DISB_ACTIVITY), igf_aw_gen.lookup_desc('IGF_DB_SF_STATUS',DDTLV.SF_STATUS), INTEREST_REBATE_AMT, CAINST.cal_type, CAINST.sequence_number, CAINST.alternate_code FROM IGF_DB_AWD_DISB_DTL DDTLV , IGS_CA_INST_ALL CAINST WHERE CAINST.CAL_TYPE(+) = DDTLV.ld_cal_type AND CAINST.SEQUENCE_NUMBER(+) = DDTLV.ld_sequence_number

View Text - HTML Formatted

SELECT DDTLV.ROW_ID
, DDTLV.AWARD_ID
, DDTLV.DISB_NUM
, DDTLV.DISB_SEQ_NUM
, DDTLV.DISB_GROSS_AMT
, DDTLV.FEE_1
, DDTLV.FEE_2
, DDTLV.DISB_NET_AMT
, DDTLV.DISB_ADJ_AMT
, DDTLV.DISB_DATE
, DDTLV.FEE_PAID_1
, DDTLV.FEE_PAID_2
, DDTLV.DISB_ACTIVITY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DDTLV.SF_STATUS
, DDTLV.SF_STATUS_DATE
, DDTLV.SF_INVOICE_NUM
, DDTLV.SPNSR_CREDIT_ID
, DDTLV.SPNSR_CHARGE_ID
, DDTLV.SF_CREDIT_ID
, DDTLV.ERROR_DESC
, DDTLV.CREATED_BY
, DDTLV.CREATION_DATE
, DDTLV.LAST_UPDATED_BY
, DDTLV.LAST_UPDATE_DATE
, DDTLV.LAST_UPDATE_LOGIN
, DDTLV.REQUEST_ID
, DDTLV.PROGRAM_APPLICATION_ID
, DDTLV.PROGRAM_ID
, DDTLV.PROGRAM_UPDATE_DATE
, DDTLV.NOTIFICATION_DATE
, IGF_AW_GEN.LOOKUP_DESC('IGF_DB_DL_DISB_STATUS'
, DDTLV.DISB_STATUS)
, IGF_AW_GEN.LOOKUP_DESC('IGF_DB_DL_ACTIVITY'
, DDTLV.DISB_ACTIVITY)
, IGF_AW_GEN.LOOKUP_DESC('IGF_DB_SF_STATUS'
, DDTLV.SF_STATUS)
, INTEREST_REBATE_AMT
, CAINST.CAL_TYPE
, CAINST.SEQUENCE_NUMBER
, CAINST.ALTERNATE_CODE
FROM IGF_DB_AWD_DISB_DTL DDTLV
, IGS_CA_INST_ALL CAINST
WHERE CAINST.CAL_TYPE(+) = DDTLV.LD_CAL_TYPE
AND CAINST.SEQUENCE_NUMBER(+) = DDTLV.LD_SEQUENCE_NUMBER