[Home] [Help]
VIEW: APPS.OKS_PRICE_BREAKS_HIST_V
Source
View Text - Preformatted
SELECT bsl_id, bcl_id, cle_id, round(QUANTITY_FROM,2)||'-'||round(quantity_to,2) price_range, QUANTITY , unit_price, amount FROM oks_price_breaks
View Text - HTML Formatted
SELECT BSL_ID
, BCL_ID
, CLE_ID
, ROUND(QUANTITY_FROM
, 2)||'-'||ROUND(QUANTITY_TO
, 2) PRICE_RANGE
, QUANTITY
, UNIT_PRICE
, AMOUNT
FROM OKS_PRICE_BREAKS