[Home] [Help]
View: QPFV_PRODUCT_EXCLUSIONS
Product: | QP - Advanced Pricing |
Description: | This view gives information about products excluded from a Modifier. |
Implementation/DBA Data: |
APPS.QPFV_PRODUCT_EXCLUSIONS
|
View Text
SELECT LIST_LINE_ID
, EXCLUDER_FLAG
, PRODUCT_ATTRIBUTE_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE)
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE)
, LIST_HEADER_ID
, PRICING_ATTRIBUTE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, '_DF:QP:QP_PRICING_ATTRIBUTES:QP_PRICING_ATTRIBUTES'
FROM QP_PRICING_ATTRIBUTES
WHERE EXCLUDER_FLAG = 'Y' WITH READ ONLY
Columns
Name |
LIST_LINE_ID |
EXCLUDER_FLAG |
PRODUCT_ATTRIBUTE_CONTEXT |
PRODUCT_ATTRIBUTE |
PRODUCT_ATTR_VALUE |
LIST_HEADER_ID |
PRICING_ATTRIBUTE_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
"_DF" |