FND Design Data [Home] [Help]

View: QPFV_FORMULA_LINES

Product: QP - Advanced Pricing
Description: This gives information about formula lines.
Implementation/DBA Data: ViewAPPS.QPFV_FORMULA_LINES
View Text

SELECT PRICE_FORMULA_LINE_ID
, PRICE_FORMULA_ID
, PRICE_LIST_LINE_ID
, PRICE_MODIFIER_LIST_ID
, PRICING_ATTRIBUTE_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, PRICING_ATTRIBUTE_CONTEXT
, PRICING_ATTRIBUTE)
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, STEP_NUMBER
, NUMERIC_CONSTANT
, PRICE_FORMULA_LINE_TYPE_CODE
, '_LA:PRICE_FORMULA_LINE_TYPE_CODE:QP_LOOKUPS:PRICE_FORMULA_LINE_TYPE_CODE:MEANING'
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, '_DF:QP:QP_PRICE_FORMULA_LINES:QP_PRICE_FORMULA_LINES'
FROM QP_PRICE_FORMULA_LINES WITH READ ONLY

Columns

Name
PRICE_FORMULA_LINE_ID
PRICE_FORMULA_ID
PRICE_LIST_LINE_ID
PRICE_MODIFIER_LIST_ID
PRICING_ATTRIBUTE_CONTEXT
PRICING_ATTRIBUTE
START_DATE_ACTIVE
END_DATE_ACTIVE
STEP_NUMBER
NUMERIC_CONSTANT
PRICE_FORMULA_LINE_TYPE_CODE
"_LA:FORMULA_LINE_TYPE_CODE"
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
"_DF"