[Home] [Help]
View: OKX_RATE_SCHEDULES_V
Product: | OKX - Contracts Integration |
Description: | Billing rates for service coverage |
Implementation/DBA Data: |
APPS.OKX_RATE_SCHEDULES_V
|
View Text
SELECT CBR.COVERAGE_BILL_RATE_ID ID1
, '#' ID2
, CBR.RATE_TYPE_CODE RATE_TYPE_CODE
, CBR.UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE
, CBR.FLAT_RATE FLAT_RATE
, CBR.PERCENT_RATE PERCENT_RATE
, CBR.RATE_TYPE_CODE NAME
, 'A' STATUS
, CBR.FLAT_RATE||' '||CBR.PERCENT_RATE||' '||CBR.UNIT_OF_MEASURE_CODE DESCRIPTION
, SYSDATE START_DATE_ACTIVE
, NULL END_DATE_ACTIVE
FROM CS_COV_BILL_RATES CBR
Columns
Name |
ID1 |
ID2 |
RATE_TYPE_CODE |
UNIT_OF_MEASURE_CODE |
FLAT_RATE |
PERCENT_RATE |
NAME |
STATUS |
DESCRIPTION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |