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;