Product: | QP - Advanced Pricing |
---|---|
Description: | This view gives the information of associated pricing attributes of a Factor list. |
Implementation/DBA Data: | APPS.QPFV_FACTOR_ASSO_PRICING_ATTRS |
SELECT PA.LIST_LINE_ID
, 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.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_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) WITH READ ONLY