FND Design Data [Home] [Help]

View: QPBV_QUALIFIERS

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

SELECT LIST_HEADER_ID
, LIST_LINE_ID
, QUALIFIER_CONTEXT
, QUALIFIER_ATTRIBUTE
, QUALIFIER_GROUPING_NO
, QUALIFIER_ATTR_VALUE
, QUALIFIER_ATTR_VALUE_TO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_FROM_RULE_ID
, QUALIFIER_PRECEDENCE
, COMPARISON_OPERATOR_CODE
, QUALIFIER_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM QP_QUALIFIERS
WHERE LIST_HEADER_ID IS NOT NULL

Columns

Name
LIST_HEADER_ID
LIST_LINE_ID
QUALIFIER_CONTEXT
QUALIFIER_ATTRIBUTE
QUALIFIER_GROUPING_NO
QUALIFIER_ATTR_VALUE
QUALIFIER_ATTR_VALUE_TO
START_DATE_ACTIVE
END_DATE_ACTIVE
CREATED_FROM_RULE_ID
QUALIFIER_PRECEDENCE
COMPARISON_OPERATOR_CODE
QUALIFIER_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY