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: OEFV_PRICE_ADJUSTMENTS

Product:	ONT - Order Management
Description:	Full BIS Business View for Price Adjustments.
Implementation/DBA Data:	APPS.OEFV_PRICE_ADJUSTMENTS

View Text

SELECT PRADJ.PRICE_ADJUSTMENT_ID
, '_LA:PRADJ.AUTOMATIC_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, PRADJ.PERCENT
, '_DF:ONT:OE_PRICE_ADJUSTMENTS:PRADJ'
, DISCOUNT.NAME
, HEADER.ORDER_NUMBER
, PRADJ.DISCOUNT_ID
, PRADJ.DISCOUNT_LINE_ID
, PRADJ.HEADER_ID
, PRADJ.LINE_ID
, PRADJ.LAST_UPDATE_DATE
, PRADJ.LAST_UPDATED_BY
, PRADJ.CREATION_DATE
, PRADJ.CREATED_BY
, '_LA:PRADJ.APPLIED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, PRADJ.OPERAND
, PRADJ.ARITHMETIC_OPERATOR
, '_LA:PRADJ.CHANGE_REASON_CODE:OE_LOOKUPS:CHANGE_CODE:MEANING'
, '_LA:PRADJ.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING'
, PRADJ.LIST_HEADER_ID
, PRADJ.LIST_LINE_ID
FROM OE_PRICE_ADJUSTMENTS PRADJ
, QP_LIST_HEADERS_TL DISCOUNT
, OE_ORDER_HEADERS_ALL HEADER
WHERE PRADJ.LIST_HEADER_ID = DISCOUNT.LIST_HEADER_ID (+)
AND DISCOUNT.LANGUAGE = USERENV('LANG')
AND PRADJ.HEADER_ID = HEADER.HEADER_ID WITH READ ONLY

Columns

Name
PRICE_ADJUSTMENT_ID
"_LA:AUTOMATICALLY_APPLIED"
PERCENT
"_DF"
DISCOUNT_NAME
ORDER_NUMBER
DISCOUNT_ID
DISCOUNT_LINE_ID
HEADER_ID
LINE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
"_LA:APPLIED_FLAG"
OPERAND
ARITHMETIC_OPERATOR
"_LA:CHANGE_REASON_CODE"
"_LA:LIST_LINE_TYPE_CODE"
LIST_HEADER_ID
LIST_LINE_ID