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

VIEW: APPS.OKC_TIME_TPG_DELIMITED_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[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.
SFWT_FLAG CHAR (1)
Indicates a value was changed in another language. Not fully implemented in 11i
TZE_ID NUMBER (15)
Surrogate key used for primary unique identifiers.
DNZ_CHR_ID NUMBER
Yes Contract ID. Denormalized for performance.
TVE_ID_LIMITED NUMBER

Surrogate key used for primary unique identifiers.
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.
MONTH NUMBER (2)
Month value.
DAY NUMBER (2)
Day value.
DAY_OF_WEEK VARCHAR2 (9)
Day of week value.
HOUR NUMBER (2)
Hour value.
MINUTE NUMBER (2)
Minute value.
SECOND NUMBER (2)
Second value.
NTH NUMBER

weekday in month
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
,      SFWT_FLAG
,      TZE_ID
,      DNZ_CHR_ID
,      TVE_ID_LIMITED
,      DESCRIPTION
,      SHORT_DESCRIPTION
,      COMMENTS
,      MONTH
,      DAY
,      DAY_OF_WEEK
,      HOUR
,      MINUTE
,      SECOND
,      NTH
,      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_TPG_DELIMITED_V;

Dependencies

[top of page]

APPS.OKC_TIME_TPG_DELIMITED_V references the following:

SchemaAPPS
SynonymOKC_TIMEVALUES
APPS.OKC_TIME_TPG_DELIMITED_V is referenced by following:

SchemaAPPS
Package BodyOKC_TGD_PVT - show dependent code
PL/SQL PackageOKC_TGD_PVT - show dependent code
PL/SQL PackageOKC_TIME_PVT - show dependent code