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

TABLE: OKS.OKS_ACTION_TIMES

Object Details
Object Name: OKS_ACTION_TIMES
Object Type: TABLE
Owner: OKS
FND Design Data: TableOKS.OKS_ACTION_TIMES
Subobject Name:
Status: VALID


OKS_ACTION_TIMES table is populated by coverage form. This table stores Reaction and Resolution times defined for business process in coverage. It stores all times related data in minutes. This information is used by entitlements to derive "React By" and "Resolve By" time for a service request. COV_ACTION_TYPE_ID column is a foreign key to ID column of OKS_ACTION_TIME_TYPES table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKS_ACTION_TIMES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
OKS_ACTION_TIMES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLE_ID
OKS_ACTION_TIMES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOV_ACTION_TYPE_ID
OKS_ACTION_TIMES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDNZ_CHR_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Unique Identifier for records in OKS_ACTION_TIMES
COV_ACTION_TYPE_ID NUMBER

Unique Identifier of OKS_ACTION_TIME_TYPES. (References OKS_ACTION_TIME_TYPES.ID).
CLE_ID NUMBER

Unique Identifier for Contract Line. Specifies the Contract Line to which this Action Time applies. Contract Line is a Reaction and Resolution type (LSE_ID is either 4, 16, or 19). (References OKC_K_LINES_B.ID)
DNZ_CHR_ID NUMBER

Unique Identifier for Contract Header, denormalized for efficiency.
UOM_CODE VARCHAR2 (30)
Unit of measure of Reaction or resolution times. Currently, only valid value is 'minutes' (�MIN�).
SUN_DURATION NUMBER

Reaction or Resolution duration in minutes on Sunday
MON_DURATION NUMBER

Reaction or Resolution duration in minutes on Monday
TUE_DURATION NUMBER

Reaction or Resolution duration in minutes on Tuesday
WED_DURATION NUMBER

Reaction or Resolution duration in minutes on Wednesday
THU_DURATION NUMBER

Reaction or Resolution duration in minutes on Thursday
FRI_DURATION NUMBER

Reaction or Resolution duration in minutes on Friday
SAT_DURATION NUMBER

Reaction or Resolution duration in minutes on Saturday
SECURITY_GROUP_ID NUMBER

Now obsolete. Used to create a Virtual Private Database which was originally designed to be used by Hosting services.
PROGRAM_APPLICATION_ID NUMBER

With PROGRAM_ID, keeps track of which concurrent program created or updated each row
PROGRAM_ID NUMBER

With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row
PROGRAM_UPDATE_DATE DATE

Date the concurrent program updated the record
REQUEST_ID NUMBER

Unique Identifier of a concurrent request
CREATED_BY NUMBER (15) Yes ID of the user who created the record
CREATION_DATE DATE
Yes Date the record was created
LAST_UPDATED_BY NUMBER (15) Yes ID of the last user who updated the record
LAST_UPDATE_DATE DATE
Yes Date the record was last updated
LAST_UPDATE_LOGIN NUMBER (15)
OS ID of the user who last updated the record
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
Query Text

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


SELECT ID
,      COV_ACTION_TYPE_ID
,      CLE_ID
,      DNZ_CHR_ID
,      UOM_CODE
,      SUN_DURATION
,      MON_DURATION
,      TUE_DURATION
,      WED_DURATION
,      THU_DURATION
,      FRI_DURATION
,      SAT_DURATION
,      SECURITY_GROUP_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM OKS.OKS_ACTION_TIMES;

Dependencies

[top of page]

OKS.OKS_ACTION_TIMES does not reference any database object

OKS.OKS_ACTION_TIMES is referenced by following:

SchemaOKS
ViewOKS_ACTION_TIMES#