[Home] [Help] [Dependency Information]
Object Name: | CS_ACTIVE_COVERAGES_RG_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
APPS.CS_ACTIVE_COVERAGES_RG_V is not referenced by any database object
|
|
|