View: OEFV_PRICE_ADJUSTMENTS

Product:	OE - Order Entry
Description:	- Retrofitted
Implementation/DBA Data:	APPS.OEFV_PRICE_ADJUSTMENTS

View Text

SELECT PRADJ.PRICE_ADJUSTMENT_ID
, LOOKUP.MEANING
, PRADJ.PERCENT
, '_DF:OE:SO_PRICE_ADJUSTMENTS:PRADJ'
, DISCOUNT.NAME
, HEADER.ORDER_NUMBER
, LINE.LINE_NUMBER
, PRADJ.DISCOUNT_ID
, DISCOUNTLN.DISCOUNT_LINE_ID
, PRADJ.HEADER_ID
, PRADJ.LINE_ID
, PRADJ.LAST_UPDATE_DATE
, PRADJ.LAST_UPDATED_BY
, PRADJ.CREATION_DATE
, PRADJ.CREATED_BY
FROM SO_PRICE_ADJUSTMENTS PRADJ
, SO_DISCOUNTS DISCOUNT
, SO_DISCOUNT_LINES DISCOUNTLN
, SO_HEADERS_ALL HEADER
, SO_LINES_ALL LINE
, SO_LOOKUPS LOOKUP
WHERE PRADJ.DISCOUNT_ID = DISCOUNT.DISCOUNT_ID
AND PRADJ.HEADER_ID = HEADER.HEADER_ID
AND PRADJ.DISCOUNT_LINE_ID = DISCOUNTLN.DISCOUNT_LINE_ID(+)
AND PRADJ.LINE_ID = LINE.LINE_ID(+)
AND LOOKUP.LOOKUP_TYPE = 'YES_NO'
AND LOOKUP.LOOKUP_CODE = PRADJ.AUTOMATIC_FLAG WITH READ ONLY

Columns