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_ART_RELS_INTERFACE

Object Details

Object Name:	OKC_ART_RELS_INTERFACE
Object Type:	TABLE
Owner:	OKC
Subobject Name:
Status:	VALID

This is the interface table for import of relationships between standard clauses from external systems. All valid data in this table will be imported to OKC_ART_RELATNS_ALL using XML Based Clause Import Concurrent program. The users are expected to upload data into this table using XML.
This is the open interface table for OKC Clause Library.
Scope: public
Lifecycle: active
Display Name: OKC Clause Import Interface
Product: OKC
Category: BUSINESS_ENTITY OKC_LIBRARY_CLAUSE

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_ID	NUMBER		Yes	Unique Identifier for each row. Users should use the sequence OKC_ART_RELS_INTERFACE_S.NEXTVAL to generate this identifier while loading data into this table.
BATCH_NUMBER	VARCHAR2	(50)	Yes	A generated code or user entered number or code to identify a batch of rows in the interface table.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
SOURCE_ARTICLE_TITLE	VARCHAR2	(450)	Yes	This references one of the two related clauses.
TARGET_ARTICLE_TITLE	VARCHAR2	(450)	Yes	This references one of the two related clauses.
ORG_ID	NUMBER			The operating unit in which the clause relationship is defined.
RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	Relationship Type between two clauses. Based on FND_LOOKUPS e.g. INCOMPATIBLE - Incompatible Clauses, ALTERNATE - Alternate Clauses.
PROCESS_STATUS	VARCHAR2	(1)		Status of the imported Relationship, as a result of the import process run in either 'Validation ' or 'Import' mode. Valid values are E - Error, W - Warning and S - Success. In 'Validation' mode, successful or records with Warnings will not have a status.Only records with errors will have a status of 'E'. System Generated - Do Not Modify.
ACTION	VARCHAR2	(1)	Yes	This column represents different options that can be performed while importing this Variable row. i.e. 'S' - Create new relationship in the system. 'D' - Delete an existing relationship .
CREATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Concurrent Program column
PROGRAM_LOGIN_ID	NUMBER			Standard Concurrent Program column
PROGRAM_APPLICATION_ID	NUMBER			Standard Concurrent Program column
REQUEST_ID	NUMBER			Standard Concurrent Program column

Query Text

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


SELECT INTERFACE_ID
,      BATCH_NUMBER
,      OBJECT_VERSION_NUMBER
,      SOURCE_ARTICLE_TITLE
,      TARGET_ARTICLE_TITLE
,      ORG_ID
,      RELATIONSHIP_TYPE
,      PROCESS_STATUS
,      ACTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OKC.OKC_ART_RELS_INTERFACE;

Dependencies

[top of page]

OKC.OKC_ART_RELS_INTERFACE does not reference any database object

OKC.OKC_ART_RELS_INTERFACE is referenced by following:

APPS: OKC_ART_RELS_INTERFACE