[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 |