FND Design Data [Home] [Help]

View: IGF_GR_RFMS_DISB_V

Product: IGF - Financial Aid
Description: Shows the recipient financial management system disbursement data
Implementation/DBA Data: ViewAPPS.IGF_GR_RFMS_DISB_V
View Text

SELECT RFMD.ROW_ID
, RFMD.RFMD_ID
, RFMD.ORIGINATION_ID
, RFMD.DISB_REF_NUM
, RFMD.DISB_DT
, RFMD.DISB_AMT
, RFMD.DB_CR_FLAG
, RFMD.DISB_ACK_ACT_STATUS
, RFMD.DISB_STATUS_DT
, RFMD.ACCPT_DISB_DT
, RFMD.DISB_ACCPT_AMT
, RFMD.ACCPT_DB_CR_FLAG
, RFMD.PYMT_PRD_START_DT
, RFMD.ACCPT_PYMT_PRD_START_DT
, RFMD.DISB_YTD_AMT
, RFMD.EDIT_CODE
, RFMD.RFMB_ID
, RFMB.BATCH_ID
, RFMB.RFMS_PROCESS_DT
, RFMD.CREATED_BY
, RFMD.CREATION_DATE
, RFMD.LAST_UPDATED_BY
, RFMD.LAST_UPDATE_DATE
, RFMD.LAST_UPDATE_LOGIN
, RFMD.ED_USE_FLAGS
FROM IGF_GR_RFMS_DISB RFMD
, IGF_GR_RFMS_BATCH RFMB
WHERE RFMB.RFMB_ID(+) = RFMD.RFMB_ID

Columns

Name
ROW_ID
RFMD_ID
ORIGINATION_ID
DISB_REF_NUM
DISB_DT
DISB_AMT
DB_CR_FLAG
DISB_ACK_ACT_STATUS
DISB_STATUS_DT
ACCPT_DISB_DT
DISB_ACCPT_AMT
ACCPT_DB_CR_FLAG
PYMT_PRD_START_DT
ACCPT_PYMT_PRD_START_DT
DISB_YTD_AMT
EDIT_CODE
RFMB_ID
BATCH_ID
RFMS_PROCESS_DT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ED_USE_FLAGS