SELECT HOLD.ROW_ID, HOLD.HOLD_ID, HOLD.AWARD_ID, HOLD.DISB_NUM, HOLD.HOLD, HOLD.HOLD_TYPE, LKP.MEANING, HOLD.HOLD_DATE, HOLD.RELEASE_FLAG, HOLD.RELEASE_DATE, HOLD.RELEASE_REASON, HOLD.CREATED_BY, HOLD.CREATION_DATE, HOLD.LAST_UPDATED_BY, HOLD.LAST_UPDATE_DATE, HOLD.LAST_UPDATE_LOGIN FROM IGF_DB_DISB_HOLDS HOLD, IGF_LOOKUPS_VIEW LKP WHERE LKP.LOOKUP_TYPE = 'IGF_DB_DISB_HOLDS' AND HOLD.HOLD = LKP.LOOKUP_CODE
SELECT HOLD.ROW_ID
, HOLD.HOLD_ID
, HOLD.AWARD_ID
, HOLD.DISB_NUM
, HOLD.HOLD
, HOLD.HOLD_TYPE
, LKP.MEANING
, HOLD.HOLD_DATE
, HOLD.RELEASE_FLAG
, HOLD.RELEASE_DATE
, HOLD.RELEASE_REASON
, HOLD.CREATED_BY
, HOLD.CREATION_DATE
, HOLD.LAST_UPDATED_BY
, HOLD.LAST_UPDATE_DATE
, HOLD.LAST_UPDATE_LOGIN
FROM IGF_DB_DISB_HOLDS HOLD
, IGF_LOOKUPS_VIEW LKP
WHERE LKP.LOOKUP_TYPE = 'IGF_DB_DISB_HOLDS'
AND HOLD.HOLD = LKP.LOOKUP_CODE
|
|
|