[Home] [Help]
View: QPBV_PRICING_ATTRIBUTES
Product: | QP - Advanced Pricing |
Description: | This view gives information about Pricing Attributes attached to a Modifier or a Price List. |
Implementation/DBA Data: |
APPS.QPBV_PRICING_ATTRIBUTES
|
View Text
SELECT PA.LIST_LINE_ID
, PA.EXCLUDER_FLAG
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE
, PA.PRODUCT_ATTR_VALUE
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE
, PA.PRICING_ATTR_VALUE_FROM
, PA.PRICING_ATTR_VALUE_TO
, PA.LIST_HEADER_ID
, PA.PRICING_PHASE_ID
, PA.QUALIFICATION_IND
, PA.PRODUCT_UOM_CODE
, PA.COMPARISON_OPERATOR_CODE
, PA.PRICING_ATTRIBUTE_ID
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
FROM QP_PRICING_ATTRIBUTES PA
WHERE PA.PRICING_ATTRIBUTE_CONTEXT IS NOT NULL
AND PA.EXCLUDER_FLAG = 'N'
Columns
Name |
LIST_LINE_ID |
EXCLUDER_FLAG |
PRODUCT_ATTRIBUTE_CONTEXT |
PRODUCT_ATTRIBUTE |
PRODUCT_ATTR_VALUE |
PRICING_ATTRIBUTE_CONTEXT |
PRICING_ATTRIBUTE |
PRICING_ATTR_VALUE_FROM |
PRICING_ATTR_VALUE_TO |
LIST_HEADER_ID |
PRICING_PHASE_ID |
QUALIFICATION_IND |
PRODUCT_UOM_CODE |
COMPARISON_OPERATOR_CODE |
PRICING_ATTRIBUTE_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |