eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.OKS_ENT_BILL_RATES_V

Object Details

Object Name:	OKS_ENT_BILL_RATES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKS.OKS_ENT_BILL_RATES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Billing Rates View For Service Contracts

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BILL_RATE_ID	NUMBER		Yes	Bill Rate Identifier
BILLING_TYPE_ID	NUMBER			Billing Type Identifier
RATE_CODE	VARCHAR2	(40)		Rate Code
RATE_NAME	VARCHAR2	(4000)		Rate Name
RATE_UOM	VARCHAR2	(3)		Rate Unit of Measure
RATE_AMOUNT	NUMBER			Rate Amount
RATE_PERCENT	NUMBER			Rate Percent
LABOR_ITEM_ID	NUMBER			Labor Item Id
INV_ORGANIZATION_ID	NUMBER			Inv Organization Id
SCH_START	VARCHAR2	(5)		Sch Start
SCH_END	VARCHAR2	(5)		Sch End
SCH_FOR_SUNDAY	VARCHAR2	(1)		Sch For Sunday
SCH_FOR_MONDAY	VARCHAR2	(1)		Sch For Monday
SCH_FOR_TUESDAY	VARCHAR2	(1)		Sch For Tuesday
SCH_FOR_WEDNESDAY	VARCHAR2	(1)		Sch For Wednesday
SCH_FOR_THURSDAY	VARCHAR2	(1)		Sch For Thursday
SCH_FOR_FRIDAY	VARCHAR2	(1)		Sch For Friday
SCH_FOR_SATURDAY	VARCHAR2	(1)		Sch For Saturday
SCH_FOR_HOLIDAY	VARCHAR2	(1)		Sch For Holiday

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BILL_RATE_ID
,      BILLING_TYPE_ID
,      RATE_CODE
,      RATE_NAME
,      RATE_UOM
,      RATE_AMOUNT
,      RATE_PERCENT
,      LABOR_ITEM_ID
,      INV_ORGANIZATION_ID
,      SCH_START
,      SCH_END
,      SCH_FOR_SUNDAY
,      SCH_FOR_MONDAY
,      SCH_FOR_TUESDAY
,      SCH_FOR_WEDNESDAY
,      SCH_FOR_THURSDAY
,      SCH_FOR_FRIDAY
,      SCH_FOR_SATURDAY
,      SCH_FOR_HOLIDAY
FROM APPS.OKS_ENT_BILL_RATES_V;

Dependencies

[top of page]

APPS.OKS_ENT_BILL_RATES_V references the following:

APPS: OKC_K_LINES_B; OKS_BILLRATE_SCHEDULES; OKS_ENT_UTIL_PVT - show dependent code

APPS.OKS_ENT_BILL_RATES_V is referenced by following:

APPS: CS_CHARGE_DETAILS_V; CS_SERVICE_BILLING_ENGINE_PVT - show dependent code