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

VIEW: APPS.OKC_TIME_RELATED_TO_EVENT_V

Object Details
Object Name: OKC_TIME_RELATED_TO_EVENT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_TIME_RELATED_TO_EVENT_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

Surrogate key used for primary unique identifiers
OPERATOR VARCHAR2 (6)
Boolean operators equivalent to phrases such as "on or before".
BEFORE_AFTER VARCHAR2 (3)
Indicates whether the Duration/Period is Before or After the referenced timevalue.
DURATION NUMBER

Time Quantity (which gets qualified with the Unit of Measure e.g. 6 months).
UOM_CODE VARCHAR2 (3)
Foreign Key to the MTL_UNITS_OF_MEASURE indicating the unit of Measure
TVE_ID_OFFSET NUMBER

Surrogate key used for primary unique identifiers.
CNH_ID NUMBER

Foreign key to OKC_CONDITION_HEADERS_B.
SPN_ID NUMBER

Foreign Key to Span
DNZ_CHR_ID NUMBER

Contract ID. Denormalized for performance.
TVE_ID_LIMITED NUMBER

Surrogate key used for primary unique identifiers.
OBJECT_VERSION_NUMBER NUMBER (9)
Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
TZE_ID NUMBER (15)
Surrogate key used for primary unique identifiers.
SFWT_FLAG CHAR (1)
Indicates a value was changed in another language. Not fully implemented in 11i
DESCRIPTION VARCHAR2 (1995)
User entered free format text description.
SHORT_DESCRIPTION VARCHAR2 (600)
User entered free format abbreviated text description.
COMMENTS VARCHAR2 (1995)
User entered comment.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield category column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
Query Text

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


SELECT ID
,      OPERATOR
,      BEFORE_AFTER
,      DURATION
,      UOM_CODE
,      TVE_ID_OFFSET
,      CNH_ID
,      SPN_ID
,      DNZ_CHR_ID
,      TVE_ID_LIMITED
,      OBJECT_VERSION_NUMBER
,      TZE_ID
,      SFWT_FLAG
,      DESCRIPTION
,      SHORT_DESCRIPTION
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKC_TIME_RELATED_TO_EVENT_V;

Dependencies

[top of page]

APPS.OKC_TIME_RELATED_TO_EVENT_V references the following:

SchemaAPPS
SynonymOKC_TIMEVALUES

APPS.OKC_TIME_RELATED_TO_EVENT_V is not referenced by any database object