Product: | IGF - Financial Aid |
---|---|
Description: | Base View for the Entity that stores the various holds put on a disbursement for a student. |
Implementation/DBA Data: | APPS.IGFBV_DISBURSEMENT_HOLDS |
SELECT HOLD.DISB_NUM
, '_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
, HOLD.HOLD_ID
, HOLD.AWARD_ID
, HOLD.CREATED_BY
, HOLD.CREATION_DATE
, HOLD.LAST_UPDATED_BY
, HOLD.LAST_UPDATE_DATE
, FABASE.PERSON_ID
FROM IGF_DB_DISB_HOLDS_ALL HOLD
, IGF_AW_AWARD_ALL AWD
, IGF_AP_FA_BASE_REC_ALL FABASE
WHERE HOLD.AWARD_ID = AWD.AWARD_ID
AND AWD.BASE_ID = FABASE.BASE_ID WITH READ ONLY