VIEW: APPS.QPFV_PRICE_BREAK_LINES

Source

View Text - Preformatted

SELECT rltd.FROM_RLTD_MODIFIER_ID ,rltd.TO_RLTD_MODIFIER_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) ,ll2.OPERAND ,pa.COMPARISON_OPERATOR_CODE ,'_LA:pa.COMPARISON_OPERATOR_CODE:QP_LOOKUPS:COMPARISON_OPERATOR:MEANING' ,ll2.ARITHMETIC_OPERATOR ,'_LA:ll2.ARITHMETIC_OPERATOR:QP_LOOKUPS:ARITHMETIC_OPERATOR:MEANING' ,ll2.LIST_LINE_TYPE_CODE ,'_LA:ll2.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING' ,ll2.CREATION_DATE ,ll2.CREATED_BY ,ll2.LAST_UPDATE_DATE ,ll2.LAST_UPDATED_BY , '_DF:QP:QP_PRICING_ATTRIBUTES:pa' ,ll2.RECURRING_VALUE ,ll2.ORIG_SYS_LINE_REF ,pa.ORIG_SYS_PRICING_ATTR_REF from qp_list_lines ll2, qp_rltd_modifiers rltd, qp_pricing_attributes pa WHERE rltd.to_rltd_modifier_id = ll2.list_line_id and rltd.rltd_modifier_grp_type = 'PRICE BREAK' and ll2.list_line_id = pa.list_line_id WITH READ ONLY

View Text - HTML Formatted

SELECT RLTD.FROM_RLTD_MODIFIER_ID
, RLTD.TO_RLTD_MODIFIER_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)
, LL2.OPERAND
, PA.COMPARISON_OPERATOR_CODE
, '_LA:PA.COMPARISON_OPERATOR_CODE:QP_LOOKUPS:COMPARISON_OPERATOR:MEANING'
, LL2.ARITHMETIC_OPERATOR
, '_LA:LL2.ARITHMETIC_OPERATOR:QP_LOOKUPS:ARITHMETIC_OPERATOR:MEANING'
, LL2.LIST_LINE_TYPE_CODE
, '_LA:LL2.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING'
, LL2.CREATION_DATE
, LL2.CREATED_BY
, LL2.LAST_UPDATE_DATE
, LL2.LAST_UPDATED_BY
, '_DF:QP:QP_PRICING_ATTRIBUTES:PA'
, LL2.RECURRING_VALUE
, LL2.ORIG_SYS_LINE_REF
, PA.ORIG_SYS_PRICING_ATTR_REF
FROM QP_LIST_LINES LL2
, QP_RLTD_MODIFIERS RLTD
, QP_PRICING_ATTRIBUTES PA
WHERE RLTD.TO_RLTD_MODIFIER_ID = LL2.LIST_LINE_ID
AND RLTD.RLTD_MODIFIER_GRP_TYPE = 'PRICE BREAK'
AND LL2.LIST_LINE_ID = PA.LIST_LINE_ID WITH READ ONLY