[Home] [Help] [Dependency Information]

TABLE: CS.CS_COVERAGES

Object Details

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_COVERAGES_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	COVERAGE_ID
CS_COVERAGES_U2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	NAME

Columns

Query Text

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

SELECT COVERAGE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      COVERAGE_LEVEL
,      TIME_BILLABLE_PERCENT
,      MAX_TIME_BILLABLE_AMOUNT
,      MATERIAL_BILLABLE_PERCENT
,      MAX_MATERIAL_BILLABLE_AMOUNT
,      EXPENSE_BILLABLE_PERCENT
,      MAX_EXPENSE_BILLABLE_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
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      RENEWAL_TERMS
,      TERMINATION_TERMS
,      EXCEPTION_COVERAGE_ID
,      COVERAGE_TEMPLATE_ID
,      TEMPLATE_FLAG
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      OBJECT_VERSION_NUMBER
,      MAX_COVERAGE_AMOUNT
,      MAX_SUPPORT_COVERAGE_AMT
FROM CS.CS_COVERAGES;

Dependencies

[top of page]

CS.CS_COVERAGES does not reference any database object

CS.CS_COVERAGES is referenced by following:

CS

CS_COVERAGES#