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.CS_ACTIVE_COVERAGES_RG_V

Object Details

Object Name:	CS_ACTIVE_COVERAGES_RG_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
COVERAGE_ID	NUMBER	(15)	Yes
NAME	VARCHAR2	(30)	Yes
DESCRIPTION	VARCHAR2	(240)
COVERAGE_LEVEL	VARCHAR2	(30)
TIME_BILLABLE_PERCENT	NUMBER	(3)
MAX_TIME_BILLABLE_AMOUNT	NUMBER
MATERIAL_BILLABLE_PERCENT	NUMBER	(3)
MAX_MATERIAL_BILLABLE_AMOUNT	NUMBER
EXPENSE_BILLABLE_PERCENT	NUMBER	(3)
MAX_EXPENSE_BILLABLE_AMOUNT	NUMBER
MAX_COVERAGE_AMOUNT	NUMBER
RESPONSE_TIME_PERIOD_CODE	VARCHAR2	(30)
RESPONSE_TIME_VALUE	NUMBER
SUNDAY_START_TIME	VARCHAR2	(5)
SUNDAY_END_TIME	VARCHAR2	(5)
MONDAY_START_TIME	VARCHAR2	(5)
MONDAY_END_TIME	VARCHAR2	(5)
TUESDAY_START_TIME	VARCHAR2	(5)
TUESDAY_END_TIME	VARCHAR2	(5)
WEDNESDAY_START_TIME	VARCHAR2	(5)
WEDNESDAY_END_TIME	VARCHAR2	(5)
THURSDAY_START_TIME	VARCHAR2	(5)
THURSDAY_END_TIME	VARCHAR2	(5)
FRIDAY_START_TIME	VARCHAR2	(5)
FRIDAY_END_TIME	VARCHAR2	(5)
SATURDAY_START_TIME	VARCHAR2	(5)
SATURDAY_END_TIME	VARCHAR2	(5)

Query Text

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


SELECT COVERAGE_ID
,      NAME
,      DESCRIPTION
,      COVERAGE_LEVEL
,      TIME_BILLABLE_PERCENT
,      MAX_TIME_BILLABLE_AMOUNT
,      MATERIAL_BILLABLE_PERCENT
,      MAX_MATERIAL_BILLABLE_AMOUNT
,      EXPENSE_BILLABLE_PERCENT
,      MAX_EXPENSE_BILLABLE_AMOUNT
,      MAX_COVERAGE_AMOUNT
,      RESPONSE_TIME_PERIOD_CODE
,      RESPONSE_TIME_VALUE
,      SUNDAY_START_TIME
,      SUNDAY_END_TIME
,      MONDAY_START_TIME
,      MONDAY_END_TIME
,      TUESDAY_START_TIME
,      TUESDAY_END_TIME
,      WEDNESDAY_START_TIME
,      WEDNESDAY_END_TIME
,      THURSDAY_START_TIME
,      THURSDAY_END_TIME
,      FRIDAY_START_TIME
,      FRIDAY_END_TIME
,      SATURDAY_START_TIME
,      SATURDAY_END_TIME
FROM APPS.CS_ACTIVE_COVERAGES_RG_V;

Dependencies

[top of page]

APPS.CS_ACTIVE_COVERAGES_RG_V references the following:

APPS: CS_COVERAGES

APPS.CS_ACTIVE_COVERAGES_RG_V is not referenced by any database object