VIEW: APPS.IGFFV_DISBURSEMENT_HOLDS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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