[Home] [Help]
View: OKS_BILLRATE_SCHEDULES_V
| Product: | OKS - Service Contracts |
| Description: | This view displays the bill rate and it's schedules for a service activity billing type defined in Coverage. |
| Implementation/DBA Data: |
APPS.OKS_BILLRATE_SCHEDULES_V
|
View Text
SELECT ID
, CLE_ID
, BT_CLE_ID
, DNZ_CHR_ID
, START_HOUR
, START_MINUTE
, END_HOUR
, END_MINUTE
, MONDAY_FLAG
, TUESDAY_FLAG
, WEDNESDAY_FLAG
, THURSDAY_FLAG
, FRIDAY_FLAG
, SATURDAY_FLAG
, SUNDAY_FLAG
, OBJECT1_ID1
, OBJECT1_ID2
, JTOT_OBJECT1_CODE
, BILL_RATE_CODE
, UOM
, FLAT_RATE
, HOLIDAY_YN
, PERCENT_OVER_LIST_PRICE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM OKS_BILLRATE_SCHEDULES
Columns
| Name |
| ID |
| CLE_ID |
| BT_CLE_ID |
| DNZ_CHR_ID |
| START_HOUR |
| START_MINUTE |
| END_HOUR |
| END_MINUTE |
| MONDAY_FLAG |
| TUESDAY_FLAG |
| WEDNESDAY_FLAG |
| THURSDAY_FLAG |
| FRIDAY_FLAG |
| SATURDAY_FLAG |
| SUNDAY_FLAG |
| OBJECT1_ID1 |
| OBJECT1_ID2 |
| JTOT_OBJECT1_CODE |
| BILL_RATE_CODE |
| UOM |
| FLAT_RATE |
| HOLIDAY_YN |
| PERCENT_OVER_LIST_PRICE |
| PROGRAM_APPLICATION_ID |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| REQUEST_ID |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |
| SECURITY_GROUP_ID |