Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT BREAKLN.PRICE_BREAK_LINES_LOW_RANGE
, BREAKLN.PRICE_BREAK_LINES_HIGH_RANGE
, BREAKLN.PRICE
, BREAKLN.START_DATE_ACTIVE
, BREAKLN.END_DATE_ACTIVE
, LOOKUP.MEANING
, BREAKLN.PERCENT
, BREAKLN.AMOUNT
, '_DF:OE:SO_PRICE_BREAK_LINES:BREAKLN'
, UOM.UNIT_OF_MEASURE
, DISCOUNTLN.DISCOUNT_LINE_ID
, BREAKLN.UNIT_CODE
, BREAKLN.LAST_UPDATE_DATE
, BREAKLN.LAST_UPDATED_BY
, BREAKLN.CREATION_DATE
, BREAKLN.CREATED_BY
FROM SO_PRICE_BREAK_LINES BREAKLN
, SO_DISCOUNT_LINES DISCOUNTLN
, MTL_UNITS_OF_MEASURE UOM
, SO_LOOKUPS LOOKUP
WHERE BREAKLN.DISCOUNT_LINE_ID = DISCOUNTLN.DISCOUNT_LINE_ID
AND LOOKUP.LOOKUP_TYPE = 'DISCOUNT_METHOD'
AND LOOKUP.LOOKUP_CODE = BREAKLN.METHOD_TYPE_CODE
AND BREAKLN.UNIT_CODE = UOM.UOM_CODE(+) WITH READ ONLY