[Home] [Help]
| 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
|
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