FND Design Data [Home] [Help]

View: QPBV_PRODUCTS

Product: QP - Advanced Pricing
Description: This view gives information about a 'Buy' Product of a Modifier or Product of a Price list.
Implementation/DBA Data: ViewAPPS.QPBV_PRODUCTS
View Text

SELECT PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE
, PRODUCT_UOM_CODE
, LIST_LINE_ID
, LIST_HEADER_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM QP_PRICING_ATTRIBUTES
WHERE EXCLUDER_FLAG = 'N'
AND (PRICING_ATTRIBUTE_CONTEXT IS NULL OR PRICING_ATTRIBUTE_CONTEXT = 'VOLUME')

Columns

Name
PRODUCT_ATTRIBUTE_CONTEXT
PRODUCT_ATTRIBUTE
PRODUCT_ATTR_VALUE
PRODUCT_UOM_CODE
LIST_LINE_ID
LIST_HEADER_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY