VIEW: OKS.OKS_PRICE_BREAKS#

Source

View Text - Preformatted

select ID ID, BSL_ID BSL_ID, BCL_ID BCL_ID, CLE_ID CLE_ID, CHR_ID CHR_ID, LINE_DETAIL_INDEX LINE_DETAIL_INDEX, LINE_INDEX LINE_INDEX, PRICING_CONTEXT PRICING_CONTEXT, PRICING_METHOD PRICING_METHOD, QUANTITY_FROM QUANTITY_FROM, QUANTITY_TO QUANTITY_TO, QUANTITY QUANTITY, BREAK_UOM BREAK_UOM, PRORATE PRORATE, UNIT_PRICE UNIT_PRICE, AMOUNT AMOUNT, PRICE_LIST_ID PRICE_LIST_ID, VALIDATED_FLAG VALIDATED_FLAG, STATUS_CODE STATUS_CODE, STATUS_TEXT STATUS_TEXT, LOCK_FLAG LOCK_FLAG, LOCKED_PRICE_LIST_ID LOCKED_PRICE_LIST_ID, LOCKED_PRICE_LIST_LINE_ID LOCKED_PRICE_LIST_LINE_ID, PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "OKS"."OKS_PRICE_BREAKS"

View Text - HTML Formatted

SELECT ID ID
, BSL_ID BSL_ID
, BCL_ID BCL_ID
, CLE_ID CLE_ID
, CHR_ID CHR_ID
, LINE_DETAIL_INDEX LINE_DETAIL_INDEX
, LINE_INDEX LINE_INDEX
, PRICING_CONTEXT PRICING_CONTEXT
, PRICING_METHOD PRICING_METHOD
, QUANTITY_FROM QUANTITY_FROM
, QUANTITY_TO QUANTITY_TO
, QUANTITY QUANTITY
, BREAK_UOM BREAK_UOM
, PRORATE PRORATE
, UNIT_PRICE UNIT_PRICE
, AMOUNT AMOUNT
, PRICE_LIST_ID PRICE_LIST_ID
, VALIDATED_FLAG VALIDATED_FLAG
, STATUS_CODE STATUS_CODE
, STATUS_TEXT STATUS_TEXT
, LOCK_FLAG LOCK_FLAG
, LOCKED_PRICE_LIST_ID LOCKED_PRICE_LIST_ID
, LOCKED_PRICE_LIST_LINE_ID LOCKED_PRICE_LIST_LINE_ID
, PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "OKS"."OKS_PRICE_BREAKS"