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

VIEW: APPS.OKS_LEVEL_ELEMENTS_V

Object Details
Object Name: OKS_LEVEL_ELEMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKS.OKS_LEVEL_ELEMENTS_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)
Row Identifier
ID NUMBER
Yes Primary Identifier
CLE_ID NUMBER

Unique Identifier for Contract Line.
DNZ_CHR_ID NUMBER

Unique Identifier for Contract Header, denomalized for efficiency.
PARENT_CLE_ID NUMBER

SEQUENCE_NUMBER VARCHAR2 (240) Yes Sequence Number
DATE_START DATE

Date Start
DATE_END DATE

AMOUNT NUMBER

Amount
DATE_REVENUE_RULE_START DATE

Date Revenue Rule Start
DATE_RECEIVABLE_GL DATE

Date Receivable GL
DATE_TRANSACTION DATE

Date Transaction
DATE_DUE DATE

Due Date
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.
DATE_PRINT DATE

Date Print
DATE_TO_INTERFACE DATE

Date To Interface
DATE_COMPLETED DATE

Date Completed
RUL_ID NUMBER
Yes RUL Identifier
CREATED_BY NUMBER (15) Yes ID of the user whom created the record.
CREATION_DATE DATE
Yes Date the record was created.
LAST_UPDATED_BY NUMBER (15) Yes ID of the last user who updated the record.
LAST_UPDATE_DATE DATE
Yes Date the record was last updated.
Query Text

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


SELECT ROW_ID
,      ID
,      CLE_ID
,      DNZ_CHR_ID
,      PARENT_CLE_ID
,      SEQUENCE_NUMBER
,      DATE_START
,      DATE_END
,      AMOUNT
,      DATE_REVENUE_RULE_START
,      DATE_RECEIVABLE_GL
,      DATE_TRANSACTION
,      DATE_DUE
,      OBJECT_VERSION_NUMBER
,      DATE_PRINT
,      DATE_TO_INTERFACE
,      DATE_COMPLETED
,      RUL_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.OKS_LEVEL_ELEMENTS_V;

Dependencies

[top of page]

APPS.OKS_LEVEL_ELEMENTS_V references the following:

SchemaAPPS
SynonymOKS_LEVEL_ELEMENTS
APPS.OKS_LEVEL_ELEMENTS_V is referenced by following:

SchemaAPPS
Package BodyOKL_BILL_STATUS_PVT - show dependent code
Package BodyOKL_CONTRACT_BOOK_PVT - show dependent code
Package BodyOKL_UBB_PVT - show dependent code
Package BodyOKS_BILL_LEVEL_ELEMENTS_PVT - show dependent code
PL/SQL PackageOKS_BILL_LEVEL_ELEMENTS_PVT - show dependent code