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

VIEW: APPS.OKC_OPERATION_LINES_V

Object Details
Object Name: OKC_OPERATION_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_OPERATION_LINES_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
ROW_ID ROWID (10)
ID NUMBER
Yes Surrogate key used for primary unique identifiers
SELECT_YN VARCHAR2 (3)
If selected for processing
PROCESS_FLAG VARCHAR2 (1)
If error while processing
OIE_ID NUMBER
Yes Surrogate key used for primary unique identifiers
SUBJECT_CHR_ID NUMBER
Yes
OBJECT_CHR_ID NUMBER

Primary key column.
SUBJECT_CLE_ID NUMBER

Primary key column.
OBJECT_CLE_ID NUMBER

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.
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.
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

MESSAGE_CODE VARCHAR2 (30)
Foreign key to FND_LOOKUPS of type OKC_OPR_LINE_MESSAGE_CODE.
PARENT_OLE_ID NUMBER

ACTIVE_YN VARCHAR2 (3)
This is a Yes/No flag used for Renewal and Renewal Consolidation mass operations. This flag indicates whether the relationship between the old contract and the new contract is Active. The relationship becomes inactive when the renewing contract is cancelled.
Query Text

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


SELECT ROW_ID
,      ID
,      SELECT_YN
,      PROCESS_FLAG
,      OIE_ID
,      SUBJECT_CHR_ID
,      OBJECT_CHR_ID
,      SUBJECT_CLE_ID
,      OBJECT_CLE_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      MESSAGE_CODE
,      PARENT_OLE_ID
,      ACTIVE_YN
FROM APPS.OKC_OPERATION_LINES_V;

Dependencies

[top of page]

APPS.OKC_OPERATION_LINES_V references the following:

SchemaAPPS
SynonymOKC_OPERATION_LINES
APPS.OKC_OPERATION_LINES_V is referenced by following:

SchemaAPPS
Package BodyOKC_OLE_PVT - show dependent code
PL/SQL PackageOKC_OLE_PVT - show dependent code
Package BodyOKS_MASSCHANGE_PVT - show dependent code