View: QPFV_PRICING_ATTRIBUTES

Product:	QP - Advanced Pricing
Description:	This view gives information about Pricing Attributes attached to a Modifier or a Price List.
Implementation/DBA Data:	APPS.QPFV_PRICING_ATTRIBUTES

View Text

SELECT PA.LIST_LINE_ID
, PA.EXCLUDER_FLAG
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE)
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE
, PA.PRODUCT_ATTR_VALUE)
, PA.PRICING_ATTRIBUTE_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_PRICING'
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE
, PA.PRICING_ATTR_VALUE_FROM)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_PRICING'
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE
, PA.PRICING_ATTR_VALUE_TO)
, PA.LIST_HEADER_ID
, PA.PRICING_PHASE_ID
, PA.QUALIFICATION_IND
, PA.PRODUCT_UOM_CODE
, MTL.UNIT_OF_MEASURE
, PA.COMPARISON_OPERATOR_CODE
, '_LA:PA.COMPARISON_OPERATOR_CODE:QP_LOOKUPS:COMPARISON_OPERATOR:MEANING'
, PA.PRICING_ATTRIBUTE_ID
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, '_DF:QP:QP_PRICING_ATTRIBUTES:PA'
FROM QP_PRICING_ATTRIBUTES PA
, MTL_UNITS_OF_MEASURE MTL
WHERE PA.PRICING_ATTRIBUTE_CONTEXT IS NOT NULL
AND PA.EXCLUDER_FLAG = 'N'
AND PA.PRODUCT_UOM_CODE = MTL.UOM_CODE (+) WITH READ ONLY

Columns