SELECT DEAL_TYPE , USER_DEAL_TYPE , NAME , AUTHORISED FROM XTR_DEAL_TYPES_V UNION SELECT LOOKUP_CODE DEAL_TYPE , MEANING USER_DEAL_TYPE , DESCRIPTION NAME , ENABLED_FLAG AUTHORISED FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'XTR_HEDGE_MISC' AND LOOKUP_CODE = 'HEDGE'