Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that stores the various holds put on a disbursement for a student. |
Implementation/DBA Data: | APPS.IGFFV_DISBURSEMENT_HOLDS |
SELECT HOLD.DISB_NUM
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, '_LA:HOLD.HOLD:IGF_LOOKUPS_VIEW:IGF_DB_DISB_HOLDS:MEANING'
, HOLD.HOLD_DATE
, HOLD.HOLD_TYPE
, HOLD.RELEASE_DATE
, '_LA:HOLD.RELEASE_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, HOLD.RELEASE_REASON
, HZ_PARTIES.PARTY_NUMBER
, HZ_PARTIES.PARTY_NAME
, ADISB.TP_CAL_TYPE
, ADISB.TP_SEQUENCE_NUMBER
, HOLD.HOLD_ID
, HOLD.AWARD_ID
, HOLD.CREATED_BY
, HOLD.CREATION_DATE
, HOLD.LAST_UPDATED_BY
, HOLD.LAST_UPDATE_DATE
, FACON.BASE_ID
FROM IGF_DB_DISB_HOLDS_ALL HOLD
, IGF_AW_AWD_DISB_ALL ADISB
, HZ_PARTIES HZ_PARTIES
, IGF_AW_AWARD_ALL AWD
, IGF_AP_FA_BASE_REC_ALL FACON
, IGS_CA_INST_ALL CI
WHERE HOLD.AWARD_ID = ADISB.AWARD_ID
AND HOLD.DISB_NUM = ADISB.DISB_NUM
AND ADISB.AWARD_ID = AWD.AWARD_ID
AND AWD.BASE_ID = FACON.BASE_ID
AND FACON.PERSON_ID = HZ_PARTIES.PARTY_ID
AND ADISB.TP_CAL_TYPE = CI.CAL_TYPE
AND ADISB.TP_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY