VIEW: APPS.OE_PRICE_FORMULA_ATTRIBS_V

Source

View Text - Preformatted

SELECT oep.price_adjustment_id , qpl.list_line_id , qpl.list_header_id , qpf.price_formula_id , qpf.step_number , qpf.price_formula_line_id , qpf.price_formula_line_type_code , qpf.pricing_attribute_context , qpf.pricing_attribute , qpf.numeric_constant , qpf.price_list_line_id , qpf.price_modifier_list_id , qpf.creation_date , qpf.created_by , qpf.last_update_date , qpf.last_updated_by , qpf.last_update_login from oe_price_adjustments oep, qp_list_lines qpl, qp_price_formula_lines qpf WHERE oep.list_header_id = qpl.list_header_id and oep.list_line_id = qpl.list_line_id and qpl.price_by_formula_id = qpf.price_formula_id

View Text - HTML Formatted

SELECT OEP.PRICE_ADJUSTMENT_ID
, QPL.LIST_LINE_ID
, QPL.LIST_HEADER_ID
, QPF.PRICE_FORMULA_ID
, QPF.STEP_NUMBER
, QPF.PRICE_FORMULA_LINE_ID
, QPF.PRICE_FORMULA_LINE_TYPE_CODE
, QPF.PRICING_ATTRIBUTE_CONTEXT
, QPF.PRICING_ATTRIBUTE
, QPF.NUMERIC_CONSTANT
, QPF.PRICE_LIST_LINE_ID
, QPF.PRICE_MODIFIER_LIST_ID
, QPF.CREATION_DATE
, QPF.CREATED_BY
, QPF.LAST_UPDATE_DATE
, QPF.LAST_UPDATED_BY
, QPF.LAST_UPDATE_LOGIN
FROM OE_PRICE_ADJUSTMENTS OEP
, QP_LIST_LINES QPL
, QP_PRICE_FORMULA_LINES QPF
WHERE OEP.LIST_HEADER_ID = QPL.LIST_HEADER_ID
AND OEP.LIST_LINE_ID = QPL.LIST_LINE_ID
AND QPL.PRICE_BY_FORMULA_ID = QPF.PRICE_FORMULA_ID