DBA Data[Home] [Help] [Dependency Information]

TABLE: CSR.CSR_TESTS_B

Object Details
Object Name: CSR_TESTS_B
Object Type: TABLE
Owner: CSR
FND Design Data: TableCSR.CSR_TESTS_B
Subobject Name:
Status: VALID


DEFINITION
Table to store Timing Scenario Definitions
EXAMPLE
MISCELLANEOUS


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSR_TESTS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnTEST_NUMBER
Columns
Name Datatype Length Mandatory Comments
TEST_NUMBER NUMBER
Yes Primary Key of the Table
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
CREATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
SECURITY_GROUP_ID NUMBER

Security Group Id
TASK_NUMBER NUMBER
Yes Task Number for which Timing is Analyzed
PLANNED_START DATE

Planned Start Date of the Task being Timed
PLANNED_END DATE

Planned End Date of the Task being Timed
PLAN_MODE VARCHAR2 (240)
Mode of Scheduling
SPARES VARCHAR2 (240)
Identifies whether Spares was Checked during the Operation
TRIPS VARCHAR2 (240)
Indicates whether the Trips were empty / full during the Timing
TDS_ROUTE VARCHAR2 (240)
If checked, indicates that the Timing was gathered with Scheduler operating in Route Mode
TDS_LOC VARCHAR2 (240)
If checked, indicates that the Timing was gathered with Scheduler operating in Estimate Mode
TDS_DFLT VARCHAR2 (240)
If checked, indicates that the Timing was gathered with Scheduler operating in Default Mode
TERRITORIES VARCHAR2 (240)
If checked, indicates that the Timing was gathered with Resource Manager API called with Territory Qualifiers
CONTRACTS VARCHAR2 (240)
If checked, indicates that the Timing was gathered with Resource Manager API called with Contracts
IB VARCHAR2 (240)
If checked, indicates that the Timing was gathered with Resource Manager API called with Installed Base
SKILLS VARCHAR2 (240)
If checked, indicates that the Timing was gathered with Resource Manager API called with Skills
TIMESTAMP DATE

Identifies the date this Timing Results was started
STOPWATCH NUMBER

Stopwatch
DESCRIPTION VARCHAR2 (4000)
Description for the current test case.
Query Text

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;

Dependencies

[top of page]

CSR.CSR_TESTS_B does not reference any database object

CSR.CSR_TESTS_B is referenced by following:

SchemaCSR
ViewCSR_TESTS_B#