DBA Data[Home] [Help]

VIEW: APPS.XTR_HEDGE_PRODUCT_TYPES_V

Source

View Text - Preformatted

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'
View Text - HTML Formatted

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'