Pricing Strategies and Linked Segment Price Lists

SELECT DISTINCT 
     price_list_id AS PriceListId, 
     STRATEGY_id, 
     STRAT_NAME, 
     description AS Description, 
     currency_code AS CurrencyCode, 
     precedence AS Precedence 
 FROM 
 ( 
     SELECT 
         plh.price_list_id AS price_list_id, 
         PSH.PRICING_STRATEGY_ID AS STRATEGY_ID, 
         PSH_TL.NAME AS STRAT_NAME, 
         plh_TL.description AS description, 
         plh.currency_code AS currency_code, 
         psd.precedence AS precedence, 
         psh.allow_price_list_override_flag AS allow_price_list_override_flag 
     FROM 
         qp_pricing_strategy_details PSD, 
         qp_price_lists_ALL_B plh, 
         QP_PRICE_LISTS_TL PLH_TL, 
         qp_pricing_strategies_all_b psh, 
         qp_pricing_strategies_tl psh_tl 
     WHERE 
         psh.pricing_strategy_id = psd.pricing_strategy_id 
         AND PLH.price_list_id = PLH_TL.price_list_id 
         AND psd.detail_entity_type_code = 'SEGMENT_PRICE_LIST' 
         AND psd.detail_entity_id = plh.price_list_id 
         AND PSH.PRICING_STRATEGY_ID = PSH_TL.PRICING_STRATEGY_ID 
 );