[Home] [Help] [Dependency Information]
Object Name: | CSR_TESTS_B# |
---|---|
Object Type: | VIEW |
Owner: | CSR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEST_NUMBER | NUMBER | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | |||
TASK_NUMBER | NUMBER | Yes | ||
PLANNED_START | DATE | |||
PLANNED_END | DATE | |||
PLAN_MODE | VARCHAR2 | (240) | ||
SPARES | VARCHAR2 | (240) | ||
TRIPS | VARCHAR2 | (240) | ||
TDS_ROUTE | VARCHAR2 | (240) | ||
TDS_LOC | VARCHAR2 | (240) | ||
TDS_DFLT | VARCHAR2 | (240) | ||
TERRITORIES | VARCHAR2 | (240) | ||
CONTRACTS | VARCHAR2 | (240) | ||
IB | VARCHAR2 | (240) | ||
SKILLS | VARCHAR2 | (240) | ||
TIMESTAMP | DATE | |||
STOPWATCH | NUMBER | |||
DESCRIPTION | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT TEST_NUMBER
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, TASK_NUMBER
, PLANNED_START
, PLANNED_END
, PLAN_MODE
, SPARES
, TRIPS
, TDS_ROUTE
, TDS_LOC
, TDS_DFLT
, TERRITORIES
, CONTRACTS
, IB
, SKILLS
, TIMESTAMP
, STOPWATCH
, DESCRIPTION
FROM CSR.CSR_TESTS_B#;
|
|
|