VIEW: APPS.IGF_AW_DB_CHG_DTLS_V

Source

View Text - Preformatted

SELECT CHGDTL.ROWID, CHGDTL.AWARD_ID, CHGDTL.DISB_NUM, CHGDTL.DISB_SEQ_NUM, CHGDTL.DISB_ACCEPTED_AMT, CHGDTL.ORIG_FEE_AMT, CHGDTL.DISB_NET_AMT, CHGDTL.DISB_DATE, CHGDTL.DISB_ACTIVITY, igf_aw_gen.lookup_desc('IGF_DB_DL_ACTIVITY', CHGDTL.DISB_ACTIVITY), CHGDTL.DISB_STATUS, igf_aw_gen.lookup_desc('IGF_DB_DL_DISB_STATUS', CHGDTL.DISB_STATUS), CHGDTL.DISB_STATUS_DATE, CHGDTL.DISB_REL_FLAG, CHGDTL.FIRST_DISB_FLAG, CHGDTL.INTEREST_REBATE_AMT, CHGDTL.DISB_CONF_FLAG, CHGDTL.PYMNT_PRD_START_DATE, CHGDTL.NOTE_MESSAGE, CHGDTL.BATCH_ID_TXT, CHGDTL.ACK_DATE, CHGDTL.BOOKING_ID_TXT, CHGDTL.BOOKING_DATE, CHGDTL.CREATED_BY, CHGDTL.CREATION_DATE, CHGDTL.LAST_UPDATED_BY, CHGDTL.LAST_UPDATE_DATE, CHGDTL.LAST_UPDATE_LOGIN, CHGDTL.PROGRAM_APPLICATION_ID, CHGDTL.PROGRAM_ID, CHGDTL.PROGRAM_UPDATE_DATE, CHGDTL.REQUEST_ID FROM IGF_AW_DB_CHG_DTLS CHGDTL

View Text - HTML Formatted

SELECT CHGDTL.ROWID
, CHGDTL.AWARD_ID
, CHGDTL.DISB_NUM
, CHGDTL.DISB_SEQ_NUM
, CHGDTL.DISB_ACCEPTED_AMT
, CHGDTL.ORIG_FEE_AMT
, CHGDTL.DISB_NET_AMT
, CHGDTL.DISB_DATE
, CHGDTL.DISB_ACTIVITY
, IGF_AW_GEN.LOOKUP_DESC('IGF_DB_DL_ACTIVITY'
, CHGDTL.DISB_ACTIVITY)
, CHGDTL.DISB_STATUS
, IGF_AW_GEN.LOOKUP_DESC('IGF_DB_DL_DISB_STATUS'
, CHGDTL.DISB_STATUS)
, CHGDTL.DISB_STATUS_DATE
, CHGDTL.DISB_REL_FLAG
, CHGDTL.FIRST_DISB_FLAG
, CHGDTL.INTEREST_REBATE_AMT
, CHGDTL.DISB_CONF_FLAG
, CHGDTL.PYMNT_PRD_START_DATE
, CHGDTL.NOTE_MESSAGE
, CHGDTL.BATCH_ID_TXT
, CHGDTL.ACK_DATE
, CHGDTL.BOOKING_ID_TXT
, CHGDTL.BOOKING_DATE
, CHGDTL.CREATED_BY
, CHGDTL.CREATION_DATE
, CHGDTL.LAST_UPDATED_BY
, CHGDTL.LAST_UPDATE_DATE
, CHGDTL.LAST_UPDATE_LOGIN
, CHGDTL.PROGRAM_APPLICATION_ID
, CHGDTL.PROGRAM_ID
, CHGDTL.PROGRAM_UPDATE_DATE
, CHGDTL.REQUEST_ID
FROM IGF_AW_DB_CHG_DTLS CHGDTL