DBA Data[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