Order Management Parameters.sql

-- SQL Query to obtain Order Management Parameters.
SELECT
	qppvl.NAME
  , qppvl.DESCRIPTION
  , qppvl.PARAMETER_CODE
  , qppvl.PARAMETER_LEVEL_CODE
  , qppvl.DOMAIN_SOURCE_CODE
  , qppvalues.PARAMETER_VALUE_CODE
  , qppvalues.ORG_ID
  , qppvalues.SITE_ID
  , qppvalues.PRICING_ENTITY_CODE
  , qppvalues.PARAMETER_LEVEL_VALUE
FROM
	fusion.QP_PRICING_PARAMETER_VALUES qppvalues
  , fusion.QP_PRICING_PARAMETERS_VL    qppvl
WHERE
	qppvl.PARAMETER_ID = qppvalues.PARAMETER_ID
ORDER BY
	qppvl.NAME
;