[Home] [Help] [Dependency Information]

TABLE: OKC.OKC_TIMEVALUES

Object Details

Object Name:	OKC_TIMEVALUES
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_TIMEVALUES
Subobject Name:
Status:	VALID

Timevalue quantifies the time component of a rule. A timevalue may either be a timepoint (e.g. Oct 15, 1999 at 13:00 hours), an interval (e.g. 2 weeks), or a cycle, which is a set of intervals (every two weeks)
-----------------------------------------------------
CYCLE:
defines a group of intervals (SPAN), arranged as a ring, which periodically recur. Each instance of recurring group may be thought of as a rotation.
-----------------------------------------------------
Time Point:
A specific point in time.
TIMEPOINTS may be absolute (January 1, 1999 at noon)
generic (Monday at 8AM)
a reference to an EVENT (an injury accident)
relative to an absolute or reference (30 days after an injury accident).
-----------------------------------------------------
TP Absolute:
An absolute point in time ie. it is a single actual point in the past present or future.
-----------------------------------------------------
TPA Relative:
A point in time relative (some duration prior to or post) to another point in time.
eg. 60 days ARO (after receipt of order)
The reference point may not have a value at specification time and the possibility
exists that it may not have obtained one by execution time.
-----------------------------------------------------
TPA Value:
A simple datetime value
-----------------------------------------------------
TP Generic:
A point in time which is general, unspecified, generic
eg. 17:00 SATURDAY
what saturday? - it is unspecified, therefore it is all saturdays - generic
-----------------------------------------------------
TPG Delimited:
this is intended to specify a point from the most detailed level up
ie. must have second, may have min, hour etc.
-----------------------------------------------------
TPG Named:
An absolute point in time ie. it is a single actual point in the past present or future, which is specified by reference to a name.
eg.
order receipt date(time)
cancellation date(time)
Note that the reference point may not have a value at specification time and the possibility
exists that it may not have obtained one by execution time.
-----------------------------------------------------
Interval:
a duration of time. It may be
absolute - an actual past present or future interval,or
generic - general, unspecified, generic
eg. SATURDAY
what saturday? - it is unspecified, therefore it is all saturdays
-----------------------------------------------------
I Absolute:
An absolute defined duration of actual past present or future time
May be defined by start and end points
eg.jan 1998 is interval x: 01/01/1998 00:00:00 <= x < 02/01/1998 00:00:00
or a start point and a duration
eg.01/01/1998 00:00:00, 1 month
-----------------------------------------------------
IA Duration:
An absolute defined duration of actual past present or future time defined by a "start" point and a duration
e.g. january 1998 = 01/01/1998 00:00:00, 1 month
note that this is an example of a case when the duration is implicit
i.e. the duration of MONTH for january is 31 days but for February it would be 28 or 29 as the case may be
-----------------------------------------------------
IA Start/End:
An absolute defined duration of actual past present or future time defined by start and end points.
eg. jan 1998 is interval x: 01/01/1998 00:00:00 <= x < 01/02/1998 00:00:00
-----------------------------------------------------
I Generic:
A generic (general, unspecified) duration of time.
A generic interval may either have
- a generic start point (e.g. Saturday 8AM) and a duration (e.g. 10 hours); or
- a generic start point and en

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_TIMEVALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DNZ_CHR_ID
OKC_TIMEVALUES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TVE_ID_OFFSET
OKC_TIMEVALUES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CNH_ID
OKC_TIMEVALUES_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ID

Columns

Query Text

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

SELECT ID
,      SPN_ID
,      TVE_ID_OFFSET
,      TVE_ID_GENERATED_BY
,      TVE_ID_STARTED
,      TVE_ID_ENDED
,      TVE_ID_LIMITED
,      CNH_ID
,      DNZ_CHR_ID
,      TVE_TYPE
,      TZE_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      UOM_CODE
,      DURATION
,      OPERATOR
,      BEFORE_AFTER
,      DATETIME
,      MONTH
,      DAY
,      HOUR
,      MINUTE
,      SECOND
,      INTERVAL_YN
,      LAST_UPDATE_LOGIN
,      NTH
,      DAY_OF_WEEK
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      NAME
,      COMMENTS
,      SHORT_DESCRIPTION
,      DESCRIPTION
FROM OKC.OKC_TIMEVALUES;

Dependencies

[top of page]

OKC.OKC_TIMEVALUES does not reference any database object

OKC.OKC_TIMEVALUES is referenced by following:

APPS

OKC_TIMEVALUES