Product: | IGF - Financial Aid |
---|---|
Description: | Base View for the Entity that holds the information about the Application Review Groups |
Implementation/DBA Data: | APPS.IGFBV_PELL_DISBURSEMENTS |
SELECT RFMD.DISB_REF_NUM
, RFMD.DISB_DT
, RFMD.DISB_AMT
, RFMD.DB_CR_FLAG
, '_LA:RFMD.DISB_ACK_ACT_STATUS:IGF_LOOKUPS_VIEW:IGF_GR_ORIG_STATUS:MEANING'
, RFMD.DISB_STATUS_DT
, RFMD.ACCPT_DISB_DT
, RFMD.DISB_ACCPT_AMT
, RFMD.ACCPT_DB_CR_FLAG
, RFMD.DISB_YTD_AMT
, RFMD.PYMT_PRD_START_DT
, RFMD.ACCPT_PYMT_PRD_START_DT
, RFMD.EDIT_CODE
, RFMD.RFMB_ID
, RFMD.ED_USE_FLAGS
, RFMD.ORIGINATION_ID
, RFMD.RFMD_ID
, RFMD.CREATED_BY
, RFMD.CREATION_DATE
, RFMD.LAST_UPDATED_BY
, RFMD.LAST_UPDATE_DATE
, FABASE.PERSON_ID
FROM IGF_GR_RFMS_DISB_ALL RFMD
, IGF_GR_RFMS_ALL RFMS
, IGF_AP_FA_BASE_REC_ALL FABASE
WHERE RFMD.ORIGINATION_ID = RFMS.ORIGINATION_ID
AND RFMS.BASE_ID = FABASE.BASE_ID WITH READ ONLY