eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKS_PRICE_BREAKS_V

Product:	OKS - Service Contracts
Description:	Service Contracts Price Breaks View
Implementation/DBA Data:	APPS.OKS_PRICE_BREAKS_V

View Text

SELECT PBR.ROWID ROW_ID
, PBR.ID ID
, PBR.BSL_ID BSL_ID
, PBR.BCL_ID BCL_ID
, PBR.CLE_ID CLE_ID
, PBR.CHR_ID CHR_ID
, PBR.LINE_DETAIL_INDEX LINE_DETAIL_INDEX
, PBR.LINE_INDEX LINE_INDEX
, PBR.PRICING_CONTEXT PRICING_CONTEXT
, PBR.PRICING_METHOD PRICING_METHOD
, PBR.QUANTITY_FROM QUANTITY_FROM
, PBR.QUANTITY_TO QUANTITY_TO
, PBR.QUANTITY QUANTITY
, PBR.BREAK_UOM BREAK_UOM
, PBR.PRORATE PRORATE
, PBR.UNIT_PRICE UNIT_PRICE
, PBR.AMOUNT AMOUNT
, PBR.PRICE_LIST_ID PRICE_LIST_ID
, PBR.VALIDATED_FLAG VALIDATED_FLAG
, PBR.STATUS_CODE STATUS_CODE
, PBR.STATUS_TEXT STATUS_TEXT
, PBR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PBR.CREATED_BY CREATED_BY
, PBR.CREATION_DATE CREATION_DATE
, PBR.LAST_UPDATED_BY LAST_UPDATED_BY
, PBR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PBR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKS_PRICE_BREAKS PBR

Columns

Name
ROW_ID
ID
BSL_ID
BCL_ID
CLE_ID
CHR_ID
LINE_DETAIL_INDEX
LINE_INDEX
PRICING_CONTEXT
PRICING_METHOD
QUANTITY_FROM
QUANTITY_TO
QUANTITY
BREAK_UOM
PRORATE
UNIT_PRICE
AMOUNT
PRICE_LIST_ID
VALIDATED_FLAG
STATUS_CODE
STATUS_TEXT
OBJECT_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN