Product: | IGF - Financial Aid |
---|---|
Description: | View for disbursement change details. |
Implementation/DBA Data: | APPS.IGF_AW_DB_CHG_DTLS_V |
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