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

VIEW: APPS.OKC_SPAN_V

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

View Type

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


Defines the legs, stages or intervals which compose a cycle, including their duration in some designated time unit.
In order to form a cycle, they must form a ring, ie. they are defined to follow each other and the "first" follows the "last" (though this has no meaning, where does a ring start and finish?)
Note that a simple recurring period, ie. 1 leg only, is defined by following itself
The SPAN may be named, eg. afternoon shift, if required
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.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
The address of the row in the database
ID NUMBER
Yes Primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
TVE_ID NUMBER
Yes Foreign key to OKC_TIMEVALUES_B.
UOM_CODE VARCHAR2 (3)
Unit of Measure code.
SPN_ID NUMBER

Surrogate key used for primary unique identifiers.
NAME VARCHAR2 (150)
Span name.
DURATION NUMBER (15) Yes Span duration.
ACTIVE_YN VARCHAR2 (3) Yes Yes/No field.
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) Yes Standard Who column.
CREATION_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column.
LAST_UPDATE_DATE DATE
Yes 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 ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      TVE_ID
,      UOM_CODE
,      SPN_ID
,      NAME
,      DURATION
,      ACTIVE_YN
,      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_SPAN_V;

Dependencies

[top of page]

APPS.OKC_SPAN_V references the following:

SchemaAPPS
SynonymOKC_SPAN
APPS.OKC_SPAN_V is referenced by following:

SchemaAPPS
PL/SQL PackageOKC_SPN_PVT - show dependent code
Package BodyOKC_SPN_PVT - show dependent code
PL/SQL PackageOKC_TIME_PVT - show dependent code