VIEW: APPS.IGFFV_PELL_DISBURSEMENTS

Source

View Text - Preformatted

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, RFMS.BASE_ID, RFMS.AWARD_ID, RFMD.RFMB_ID, RFMB.BATCH_ID, RFMB.RFMS_PROCESS_DT, RFMD.ED_USE_FLAGS, HZ_PARTIES.PARTY_NUMBER, HZ_PARTIES.PARTY_NAME, CI.ALTERNATE_CODE, CI.DESCRIPTION, RFMS.CI_CAL_TYPE, RFMS.CI_SEQUENCE_NUMBER, RFMD.ORIGINATION_ID, RFMD.RFMD_ID, RFMD.CREATED_BY, RFMD.CREATION_DATE, RFMD.LAST_UPDATED_BY, RFMD.LAST_UPDATE_DATE, FACON.PERSON_ID FROM IGF_GR_RFMS_DISB_ALL RFMD, IGF_GR_RFMS_ALL RFMS, IGS_CA_INST_ALL CI, IGF_GR_RFMS_BATCH_ALL RFMB, HZ_PARTIES HZ_PARTIES, IGF_AW_AWARD_ALL AWD, IGF_AP_FA_BASE_REC_ALL FACON WHERE RFMD.ORIGINATION_ID = RFMS.ORIGINATION_ID AND RFMD.RFMB_ID = RFMB.RFMB_ID(+) AND RFMS.CI_CAL_TYPE = CI.CAL_TYPE AND RFMS.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND RFMS.AWARD_ID = AWD.AWARD_ID AND AWD.BASE_ID = FACON.BASE_ID AND RFMS.BASE_ID = FACON.BASE_ID AND FACON.PERSON_ID = HZ_PARTIES.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

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
, RFMS.BASE_ID
, RFMS.AWARD_ID
, RFMD.RFMB_ID
, RFMB.BATCH_ID
, RFMB.RFMS_PROCESS_DT
, RFMD.ED_USE_FLAGS
, HZ_PARTIES.PARTY_NUMBER
, HZ_PARTIES.PARTY_NAME
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, RFMS.CI_CAL_TYPE
, RFMS.CI_SEQUENCE_NUMBER
, RFMD.ORIGINATION_ID
, RFMD.RFMD_ID
, RFMD.CREATED_BY
, RFMD.CREATION_DATE
, RFMD.LAST_UPDATED_BY
, RFMD.LAST_UPDATE_DATE
, FACON.PERSON_ID
FROM IGF_GR_RFMS_DISB_ALL RFMD
, IGF_GR_RFMS_ALL RFMS
, IGS_CA_INST_ALL CI
, IGF_GR_RFMS_BATCH_ALL RFMB
, HZ_PARTIES HZ_PARTIES
, IGF_AW_AWARD_ALL AWD
, IGF_AP_FA_BASE_REC_ALL FACON
WHERE RFMD.ORIGINATION_ID = RFMS.ORIGINATION_ID
AND RFMD.RFMB_ID = RFMB.RFMB_ID(+)
AND RFMS.CI_CAL_TYPE = CI.CAL_TYPE
AND RFMS.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND RFMS.AWARD_ID = AWD.AWARD_ID
AND AWD.BASE_ID = FACON.BASE_ID
AND RFMS.BASE_ID = FACON.BASE_ID
AND FACON.PERSON_ID = HZ_PARTIES.PARTY_ID WITH READ ONLY