[Home] [Help]
View: IGF_SL_DB_COD_REP_V
Product: | IGF - Financial Aid |
Description: | View used for reporting the disbursement tags in the outbound XML file. |
Implementation/DBA Data: |
APPS.IGF_SL_DB_COD_REP_V
|
View Text
SELECT TRIM(DOCUMENT_ID_TXT)
, TRIM(REP_ENTITY_ID_TXT)
, TRIM(ATD_ENTITY_ID_TXT)
, AWARD_ID
, DISB_NUM
, DISB_ACCEPTED_AMT
, TO_CHAR(DISB_DATE
, 'YYYY-MM-DD')
, DISB_REL_FLAG
, DISB_SEQ_NUM
, NOTE_MESSAGE
, FIRST_DISB_FLAG
, DISB_NET_AMT
, ORIG_FEE_AMT
, INTEREST_REBATE_AMT
, DISB_CONF_FLAG
, TO_CHAR( PYMNT_PER_START_DATE
, 'YYYY-MM-DD')
FROM IGF_AW_DB_COD_DTLS
Columns
Name |
DOCUMENT_ID_TXT |
REP_ENTITY_ID_TXT |
ATD_ENTITY_ID_TXT |
AWARD_ID |
DISB_NUM |
DISB_ACCEPTED_AMT |
DISB_DATE |
DISB_REL_FLAG |
DISB_SEQ_NUM |
NOTE_MESSAGE |
FIRST_DISB_FLAG |
DISB_NET_AMT |
ORIG_FEE_AMT |
INTEREST_REBATE_AMT |
DISB_CONF_FLAG |
PYMNT_PER_START_DATE |