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]

TABLE: OKC.OKC_OPERATION_INSTANCES

Object Details

Object Name:	OKC_OPERATION_INSTANCES
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_OPERATION_INSTANCES
Subobject Name:
Status:	VALID

An Operation Instance is an instance of a Contract Operation. The Operation Instance contains information about the instance and serves as a collection point for detailed information.
The operation may or may not have occurred. If it has occurred, then the information in Operation Instance serves as an audit trial and may not be changed. If it has not occurred, then the information in Operation Instance and associated entities describes what would occur and some of it may be changed.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_OPERATION_INSTANCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKC_OPERATION_INSTANCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COP_ID
OKC_OPERATION_INSTANCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TARGET_CHR_ID
OKC_OPERATION_INSTANCES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Unique identifier. Primary key of the table.
COP_ID	NUMBER		Yes	Unique identifier for operation. Refers to ID in OKC_CLASS_OPERATIONS.
STATUS_CODE	VARCHAR2	(30)	Yes	Status Code. Refers to lookup_code in FND_LOOKUP_VALUES where lookup_type = OKS_OPERATION_STATUS
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.
NAME	VARCHAR2	(150)		Name of the operation instance
TARGET_CHR_ID	NUMBER			Unique identifier of target document. Refers to ID in OKC_K_HEADERS_B.
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
JTOT_OBJECT1_CODE	VARCHAR2	(30)		Reference to JTF_OBJECTS for Update Level
OBJECT1_ID1	VARCHAR2	(40)		First part of the primary key to capture the value of update level
OBJECT1_ID2	VARCHAR2	(200)		Second part of the primary key to capture the value of update level
BATCH_ID	NUMBER			Instance Mass Update Batch Identifier. Foreign key to OKS_BATCH_RULES.BATCH_ID

Query Text

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


SELECT ID
,      COP_ID
,      STATUS_CODE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NAME
,      TARGET_CHR_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SECURITY_GROUP_ID
,      JTOT_OBJECT1_CODE
,      OBJECT1_ID1
,      OBJECT1_ID2
,      BATCH_ID
FROM OKC.OKC_OPERATION_INSTANCES;

Dependencies

[top of page]

OKC.OKC_OPERATION_INSTANCES does not reference any database object

OKC.OKC_OPERATION_INSTANCES is referenced by following:

APPS: OKC_OPERATION_INSTANCES