eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGF_AW_DB_CHG_DTLS_V

Product:	IGF - Financial Aid
Description:	View for disbursement change details.
Implementation/DBA Data:	APPS.IGF_AW_DB_CHG_DTLS_V

View Text

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

Columns

Name
ROW_ID
AWARD_ID
DISB_NUM
DISB_SEQ_NUM
DISB_ACCEPTED_AMT
ORIG_FEE_AMT
DISB_NET_AMT
DISB_DATE
DISB_ACTIVITY
DISB_ACTIVITY_DESC
DISB_STATUS
DISB_STATUS_DESC
DISB_STATUS_DATE
DISB_REL_FLAG
FIRST_DISB_FLAG
INTEREST_REBATE_AMT
DISB_CONF_FLAG
PYMNT_PRD_START_DATE
NOTE_MESSAGE
BATCH_ID_TXT
ACK_DATE
BOOKING_ID_TXT
BOOKING_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID