Pricing Strategy Assignment Rules.sql

SELECT
	mt.name
  , sa.strategy_assignment_level_code
  , sa.pricing_context_code
  , sa.transaction_type_code
  , mr.*
FROM
	fusion.qp_strategy_assignments sa
  , fusion.qp_matrix_types_vl      mt
  , fusion.qp_matrix_rules_vl      mr
WHERE
	sa.strategy_assignment_matrix_id = mr.dynamic_matrix_id
	AND mt.dynamic_matrix_class_id   = mr.dynamic_matrix_class_id
	AND mt.matrix_type_code          = 'QP_SALES_PRC_STRATEGY_ASGN'
ORDER BY
	1
  , 2
  , 3
  , 4
;