VIEW: APPS.QPFV_FACTOR_ASSO_PRICING_ATTRS

Source

View Text - Preformatted

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' ,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) WITH READ ONLY

View Text - HTML Formatted

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'
, 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) WITH READ ONLY