Pricing Lookup Values Defined for Customer Profiles

-- Obtain Customer Profile 
 SELECT 
     hz.party_name, 
     qcpp.* 
 FROM 
     fusion.QP_CUST_PRICING_PROFILES qcpp, 
     fusion.hz_parties hz 
 WHERE 
     hz.party_id = customer_party_id 
 ORDER BY Party_name; 
  
 -- Obtain Lookup Values used for Customer Profiles 
 SELECT * 
 FROM fusion.fnd_lookups 
 WHERE lookup_type IN ('ORA_QP_REV_POTENTIAL_VALUES', 'ORA_QP_COST_TO_SERVE', 'ORA_QP_CUSTOMER_VALUE_RANKINGS', 'ORA_QP_CUSTOMER_RATING_VALUES', 'ORA_QP_CUSTOMER_SIZE_VALUES') 
 ORDER BY lookup_type, lookup_code;