VIEW: APPS.QPBV_FACTOR_BASE_PRICING_ATTRS

Source

View Text - Preformatted

SELECT pa.LIST_LINE_ID ,pa.PRICING_ATTRIBUTE_CONTEXT ,pa.PRICING_ATTRIBUTE ,pa.PRICING_ATTR_VALUE_FROM ,pa.PRICING_ATTR_VALUE_TO ,ll.OPERAND ,ll.START_DATE_ACTIVE ,ll.END_DATE_ACTIVE ,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 ,pa.ORIG_SYS_HEADER_REF ,pa.ORIG_SYS_LINE_REF ,pa.ORIG_SYS_PRICING_ATTR_REF 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)

View Text - HTML Formatted

SELECT PA.LIST_LINE_ID
, PA.PRICING_ATTRIBUTE_CONTEXT
, PA.PRICING_ATTRIBUTE
, PA.PRICING_ATTR_VALUE_FROM
, PA.PRICING_ATTR_VALUE_TO
, LL.OPERAND
, LL.START_DATE_ACTIVE
, LL.END_DATE_ACTIVE
, 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
, PA.ORIG_SYS_HEADER_REF
, PA.ORIG_SYS_LINE_REF
, PA.ORIG_SYS_PRICING_ATTR_REF
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)