DBA Data[Home] [Help]

VIEW: APPS.OKX_RATE_SCHEDULES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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