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
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
|
|
|