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