[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 |