[Home] [Help] [Dependency Information]

VIEW: APPS.OKC_TIMEVALUES_V

Object Details

Object Name:	OKC_TIMEVALUES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKC.OKC_TIMEVALUES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

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)
Term, Duration, Period, Interval, Shift,Cycle,Continuance
Days,Dates,Times,Periods,Durations,Seasons,Shifts etc.
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) or NAMED DAY, or relative to an absolute or reference (30 days after an injury accident).
An absolute point in time ie. it is a single actual point in the past present or future
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.
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)
If the before/after attribute is used, it may mean the duration starts before the given ("start") date, e.g. "7 days prior to the end of January". The default setting is after, or a start point and a duration. The "before" setting flips this to mean a duration and an end point.
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 end point (e.g. Saturday 8AM to Saturday at 5PM).
A named generic interval which implicitly defines its own bounds (given a context).
eg.
SATURDAY = the interval x: dd/mm/yyyy 00:00 <= x < dd/mm/yyyy + 1 00:00 for any dd/mm/yyyy which is a Saturday! The context required here is the value of dd/mm/yyyy.
The result can be thought of as the intervals themselves or as points (taken to be the start point of each interval). Thus a CYCLE defines either recurring points separated by various intervals, or recurring intervals. Some intervals may be defined as inactive eg. a CYCLE of WORKWEEK may have 7 intervals of 1 DAY in duration, of which 2 are inactive.
The actual instances of SPAN (and therefore rotation) may be be either calculated from the definitions when required, or generated once (as far into the forseeable future as seems appropriate - this is specified by the end point of the CYCLE) into the appropriate tables for either actual point or interval.

[View Source]

Columns

Query Text

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

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

Dependencies

[top of page]

APPS

OKC_TIMEVALUES

APPS

OKC_COPY_CONTRACT_PVT - show dependent code

OKC_COPY_CONTRACT_PVT - show dependent code

OKS_COVERAGES_PVT - show dependent code

OKS_COVERAGE_MIGRATION - show dependent code

OKS_TIMEVALUES_V