SELECT deal_type, product_Type, product_desc, product_auth from xtr_product_Types_v union select 'HEDGE' deal_type, lookup_code product_type, meaning product_desc, enabled_flag authorised from fnd_lookups WHERE lookup_type = 'XTR_HEDGE_APPROACH'
SELECT DEAL_TYPE
, PRODUCT_TYPE
, PRODUCT_DESC
, PRODUCT_AUTH
FROM XTR_PRODUCT_TYPES_V UNION SELECT 'HEDGE' DEAL_TYPE
, LOOKUP_CODE PRODUCT_TYPE
, MEANING PRODUCT_DESC
, ENABLED_FLAG AUTHORISED
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'XTR_HEDGE_APPROACH'
|
|
|