Product: | QP - Advanced Pricing |
---|---|
Description: | This view gives information about Qualifiers attached to a Modifier or a Price List. |
Implementation/DBA Data: |
![]() |
SELECT LIST_HEADER_ID
, LIST_LINE_ID
, QUALIFIER_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_QUALIFIER'
, QUALIFIER_CONTEXT
, QUALIFIER_ATTRIBUTE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_QUALIFIER'
, QUALIFIER_CONTEXT
, QUALIFIER_ATTRIBUTE
, QUALIFIER_ATTR_VALUE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_QUALIFIER'
, QUALIFIER_CONTEXT
, QUALIFIER_ATTRIBUTE
, QUALIFIER_ATTR_VALUE_TO)
, QUALIFIER_GROUPING_NO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_FROM_RULE_ID
, QUALIFIER_PRECEDENCE
, COMPARISON_OPERATOR_CODE
, '_LA:COMPARISON_OPERATOR_CODE:QP_LOOKUPS:COMPARISON_OPERATOR:MEANING'
, QUALIFIER_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, '_DF:QP:QP_QUALIFIERS:QP_QUALIFIERS'
FROM QP_QUALIFIERS
WHERE LIST_HEADER_ID IS NOT NULL WITH READ ONLY