View: QPBV_FACTOR_ASSO_PRICING_ATTRS

Product:	QP - Advanced Pricing
Description:	This view gives the information of associated pricing attributes of a Factor list.
Implementation/DBA Data:	APPS.QPBV_FACTOR_ASSO_PRICING_ATTRS

View Text

SELECT PA.LIST_LINE_ID
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE
, PA.PRICING_ATTR_VALUE_FROM
, PA.PRICING_ATTR_VALUE_TO
, PA.LIST_HEADER_ID
, PA.COMPARISON_OPERATOR_CODE
, PA.PRICING_ATTRIBUTE_ID
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
FROM QP_LIST_LINES LL
, QP_PRICING_ATTRIBUTES PA
WHERE LL.LIST_LINE_ID = PA.LIST_LINE_ID
AND LL.LIST_LINE_TYPE_CODE = 'PMR'
AND PA.PRICING_ATTRIBUTE_ID > (SELECT MIN(PRICING_ATTRIBUTE_ID) FROM QP_PRICING_ATTRIBUTES PA1 WHERE PA1.LIST_LINE_ID = PA.LIST_LINE_ID)

Columns