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'
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'
|
|
|