Obtain Pricing Lookup Values Defined for Customer Profiles.sql

-- 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 which are used to set the 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