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_COVER_TIMES_V

Object Details

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

View Type

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

List if actual coverages attached to a contract line.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COVERAGE_ID	NUMBER			Internal Unique Identifier of a Coverage.
BUSINESS_PROCESS_ID	NUMBER	(15)	Yes	Business Process Identifier(Transaction Group)
BUSINESS_PROCESS_NAME	VARCHAR2	(90)	Yes	Name of the transaction group
TIME_ZONE_ID	NUMBER			Time Zone Identifier
TIME_ZONE_NAME	VARCHAR2	(80)	Yes	Name of the Time Zone
COVERAGE_ON	VARCHAR2	(0)		Coverage On(Which day)
COVERAGE_FROM	VARCHAR2	(5)		Coverage From(Time)
COVERAGE_TO	VARCHAR2	(5)		Coverage Upto (Time)
COVERAGE_ON_SUNDAY	VARCHAR2	(1)		Coverage On Sunday
COVERAGE_ON_MONDAY	VARCHAR2	(1)		Coverage On Monday
COVERAGE_ON_TUESDAY	VARCHAR2	(1)		Coverage On Tuesday
COVERAGE_ON_WEDNESDAY	VARCHAR2	(1)		Coverage On Wednesday
COVERAGE_ON_THURSDAY	VARCHAR2	(1)		Coverage On Thursday
COVERAGE_ON_FRIDAY	VARCHAR2	(1)		Coverage On Friday
COVERAGE_ON_SATURDAY	VARCHAR2	(1)		Coverage On Saturday

Query Text

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


SELECT COVERAGE_ID
,      BUSINESS_PROCESS_ID
,      BUSINESS_PROCESS_NAME
,      TIME_ZONE_ID
,      TIME_ZONE_NAME
,      COVERAGE_ON
,      COVERAGE_FROM
,      COVERAGE_TO
,      COVERAGE_ON_SUNDAY
,      COVERAGE_ON_MONDAY
,      COVERAGE_ON_TUESDAY
,      COVERAGE_ON_WEDNESDAY
,      COVERAGE_ON_THURSDAY
,      COVERAGE_ON_FRIDAY
,      COVERAGE_ON_SATURDAY
FROM APPS.OKS_ENT_COVER_TIMES_V;

Dependencies

[top of page]

APPS.OKS_ENT_COVER_TIMES_V references the following:

APPS: OKC_K_ITEMS; OKC_K_LINES_B; OKS_COVERAGE_TIMES; OKS_COVERAGE_TIMEZONES; OKX_BUS_PROCESSES_V; OKX_TIMEZONES_V

APPS.OKS_ENT_COVER_TIMES_V is not referenced by any database object