FND Design Data [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: ViewAPPS.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