[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: |
APPS.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 |