VIEW: APPS.QPFV_ADDITIONAL_BUY_PRODUCTS

Source

View Text - Preformatted

SELECT rltd.FROM_RLTD_MODIFIER_ID ,rltd.TO_RLTD_MODIFIER_ID ,pa.PRODUCT_ATTRIBUTE_CONTEXT ,QP_QP_Form_Pricing_Attr.Get_Attribute('QP_ATTR_DEFNS_PRICING',pa.product_attribute_context,pa.product_attribute) ,qp_price_list_line_util.get_product_value('QP_ATTR_DEFNS_PRICING',pa.product_attribute_context,pa.product_attribute,pa.product_attr_value) ,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) ,rltd.RLTD_MODIFIER_GRP_NO ,pa.PRODUCT_UOM_CODE ,mtl.UNIT_OF_MEASURE ,pa.COMPARISON_OPERATOR_CODE ,'_LA:pa.COMPARISON_OPERATOR_CODE:QP_LOOKUPS:COMPARISON_OPERATOR:MEANING' ,pa.CREATION_DATE ,pa.CREATED_BY ,pa.LAST_UPDATE_DATE ,pa.LAST_UPDATED_BY ,pa.orig_sys_pricing_attr_ref , '_DF:QP:QP_PRICING_ATTRIBUTES:pa' from qp_rltd_modifiers rltd, qp_pricing_attributes pa, mtl_units_of_measure mtl WHERE rltd.rltd_modifier_grp_type = 'QUALIFIER' and rltd.to_rltd_modifier_id = pa.list_line_id and pa.product_uom_code = mtl.uom_code (+) WITH READ ONLY

View Text - HTML Formatted

SELECT RLTD.FROM_RLTD_MODIFIER_ID
, RLTD.TO_RLTD_MODIFIER_ID
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE)
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE
, PA.PRODUCT_ATTR_VALUE)
, 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)
, RLTD.RLTD_MODIFIER_GRP_NO
, PA.PRODUCT_UOM_CODE
, MTL.UNIT_OF_MEASURE
, PA.COMPARISON_OPERATOR_CODE
, '_LA:PA.COMPARISON_OPERATOR_CODE:QP_LOOKUPS:COMPARISON_OPERATOR:MEANING'
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.ORIG_SYS_PRICING_ATTR_REF
, '_DF:QP:QP_PRICING_ATTRIBUTES:PA'
FROM QP_RLTD_MODIFIERS RLTD
, QP_PRICING_ATTRIBUTES PA
, MTL_UNITS_OF_MEASURE MTL
WHERE RLTD.RLTD_MODIFIER_GRP_TYPE = 'QUALIFIER'
AND RLTD.TO_RLTD_MODIFIER_ID = PA.LIST_LINE_ID
AND PA.PRODUCT_UOM_CODE = MTL.UOM_CODE (+) WITH READ ONLY