[Home] [Help]
View: OKS_PRICE_BREAKS_HIST_V
| Product: | OKS - Service Contracts |
| Description: | View used in Billing form to display the Details of usage billing |
| Implementation/DBA Data: |
APPS.OKS_PRICE_BREAKS_HIST_V
|
View Text
SELECT BSL_ID
, BCL_ID
, CLE_ID
, QUANTITY_FROM||'-'||QUANTITY_TO PRICE_RANGE
, QUANTITY
, UNIT_PRICE
, AMOUNT
FROM OKS_PRICE_BREAKS
Columns
| Name |
| BSL_ID |
| BCL_ID |
| CLE_ID |
| PRICE_RANGE |
| QUANTITY |
| UNIT_PRICE |
| AMOUNT |