eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKC_TIME_IA_STARTEND_REL_V

Object Details

Object Name:	OKC_TIME_IA_STARTEND_REL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKC.OKC_TIME_IA_STARTEND_REL_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
START_PARENT_DATE	DATE			A Point in Time timevalue which is referring to the start of an interval.
START_DATE	DATE			The beginning of the active period, one second after midnight on the date indicated.
END_DATE	DATE			The end of the active period, one second before midnight on the date indicated.
ID	NUMBER		Yes	Surrogate key used for primary unique identifiers
TZE_ID	NUMBER	(15)		Surrogate key used for primary unique identifiers.
START_UOM_CODE	VARCHAR2	(3)		Foreign Key to the MTL_UNITS_OF_MEASURE indicating the unit of Measure .
START_DURATION	NUMBER	(10)		Time Quantity (which gets qualified with the Unit of Measure e.g. 6 months). This is the offset value from the START_PARENT_DATE.
START_TVE_ID_OFFSET	NUMBER			Foreign Key to another Time Value (recursive relationship). In this case it is pointing to the Interval created by the Start Parent Date, Start_UOM_CODE and Start_Duration.
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.
SFWT_FLAG	CHAR	(1)		Indicates a value was changed in another language. Not fully implemented in 11i
TVE_ID_STARTED	NUMBER			Surrogate key used for primary unique identifiers.
TVE_ID_ENDED	NUMBER			Surrogate key used for primary unique identifiers.
TVE_ID_LIMITED	NUMBER			Surrogate key used for primary unique identifiers.
DNZ_CHR_ID	NUMBER		Yes	Contract ID. Denormalized for performance.
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.
OPERATOR	VARCHAR2	(6)		Boolean operators equivalent to phrases such as "on or before".
DURATION	NUMBER	(10)		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
BEFORE_AFTER	VARCHAR2	(3)		Indicates whether the Duration/Period is Before or After the Start_Tve_Id_Offset.
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 START_PARENT_DATE
,      START_DATE
,      END_DATE
,      ID
,      TZE_ID
,      START_UOM_CODE
,      START_DURATION
,      START_TVE_ID_OFFSET
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      TVE_ID_STARTED
,      TVE_ID_ENDED
,      TVE_ID_LIMITED
,      DNZ_CHR_ID
,      DESCRIPTION
,      SHORT_DESCRIPTION
,      COMMENTS
,      OPERATOR
,      DURATION
,      UOM_CODE
,      BEFORE_AFTER
,      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_IA_STARTEND_REL_V;

Dependencies

[top of page]

APPS.OKC_TIME_IA_STARTEND_REL_V references the following:

APPS: OKC_TIME_IA_STARTEND_V; OKC_TIME_IA_STARTEND_VAL_V; OKC_TIME_TPA_RELATIVE_V; OKC_TIME_UTIL_PUB - show dependent code

APPS.OKC_TIME_IA_STARTEND_REL_V is referenced by following:

APPS: OKC_COPY_CONTRACT_PVT - show dependent code