FND Design Data [Home] [Help]

View: QPFV_QUALIFIERS

Product: QP - Advanced Pricing
Description: This view gives information about Qualifiers attached to a Modifier or a Price List.
Implementation/DBA Data: ViewAPPS.QPFV_QUALIFIERS
View Text

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

Columns

Name
LIST_HEADER_ID
LIST_LINE_ID
QUALIFIER_CONTEXT
QUALIFIER_ATTRIBUTE
QUALIFIER_ATTR_VALUE
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"
QUALIFIER_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
"_DF"