FND Design Data [Home] [Help]

View: QPFV_PRODUCT_EXCLUSIONS

Product: QP - Advanced Pricing
Description: This view gives information about products excluded from a Modifier.
Implementation/DBA Data: ViewAPPS.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"