eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OE_PRICE_FORMULA_ATTRIBS_V

Product:	ONT - Order Management
Description:	This view stores the pricing formula attributes for freight charges.
Implementation/DBA Data:	APPS.OE_PRICE_FORMULA_ATTRIBS_V

View Text

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

Columns

Name
PRICE_ADJUSTMENT_ID
LIST_LINE_ID
LIST_HEADER_ID
PRICE_FORMULA_ID
STEP_NUMBER
PRICE_FORMULA_LINE_ID
PRICE_FORMULA_LINE_TYPE_CODE
PRICING_ATTRIBUTE_CONTEXT
PRICING_ATTRIBUTE
NUMERIC_CONSTANT
PRICE_LIST_LINE_ID
PRICE_MODIFIER_LIST_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN