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_INTERFACE_ALL

Object Details

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

This is the interface table for import of standard clauses from external systems. All valid data in this table will be imported to OKC_ARTICLES_ALL, OKC_ARTICLE_VERSIONS and OKC_ARTICLE_ADOPTIONS by the Clause Import Concurrent program. The users are expected to upload data into this table using SQL*Loader, Pro*C or other tools.
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:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_ART_INTERFACE_ALL_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	INTERFACE_ID
SYS_IL0000329261C00016$$	LOB	UNIQUE	APPS_TS_INTERFACE
OKC_ART_INTERFACE_ALL_U2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_NUMBER ARTICLE_TITLE ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_ID	NUMBER		Yes	Unique Identifier for each row. Users should use the sequence OKC_ART_INTERFACE_ALL_S1.NEXTVAL to generate this identifier while loading data into this table.
BATCH_NUMBER	VARCHAR2	(50)	Yes	A user entered number or code to identify a batch of rows in the interface table. e.g. Tom06152004 i.e. user's name followed by the system date. The users will be prompted for a batch number during the clause import process.
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.
ARTICLE_TITLE	VARCHAR2	(450)	Yes	The Title for the clause. This is unique for a given operating unit
ORG_ID	NUMBER			The operating unit into which the clause is imported.
PROCESS_STATUS	VARCHAR2	(1)		Status of the imported Clause, 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 Clause row. i.e. 'N' - New Clause will be created. 'U' - Update an existing Draft or Rejected clause in the library. 'V' - Create a new version for the clause .
ARTICLE_NUMBER	VARCHAR2	(240)		Clause Number - will be used for new clauses (Only applicable when Action = 'N'). Is required, if organization does not use autonumbering based on document sequence setup for clause number.
ARTICLE_INTENT	VARCHAR2	(1)	Yes	Intent for the Clause. Valid Values are B - Buy and S - Sell. (Only applicable when Action='N')
ARTICLE_LANGUAGE	VARCHAR2	(4)	Yes	Language of the clause text (referred as article_text in this table). If it is not provided, the client language for the user submitting the import request will be used.(Only applicable when Action='N')
ARTICLE_TYPE	VARCHAR2	(30)		Subject Code or Type of the Clause. Foreign Key to lookup_code in FND_LOOKUPS where Lookup_Type = OKC_SUBJECT. Please use lookup code exactly not meaning.
ART_SYSTEM_REFERENCE_CODE	VARCHAR2	(30)		Any user defined code to indicate that this is imported from an external system. User can refer to the external system record with this code and the reference id columns. User FYI only.
ART_SYSTEM_REFERENCE_ID1	VARCHAR2	(100)		Id of the external system row being imported to the library. User can refer to the external system record with the Original System Code and the reference id columns. User FYI only.
ART_SYSTEM_REFERENCE_ID2	VARCHAR2	(100)		Additional (composite) id of the external system row being imported to the library. User can refer to the external system record with the Original System Code and the reference id columns. User FYI only.
ARTICLE_VERSION_NUMBER	NUMBER			System will determine and generate. For example, with action 'N', the version number will be 1, with action 'U', most recent 'Draft' or 'Rejected' version number will be stamped and with action 'V', the most recent 'Approved' or 'On Hold' article version number +1 will be stamped.
ARTICLE_TEXT	CLOB	(4000)		Text of the clause which articulates the legal or regulatory or business term. Clause text could include valid system or user-defined Variables defined in OKC_BUS_VARIABLES_B/_TL.
PROVISION_YN	VARCHAR2	(1)	Yes	Yes/No flag to indicate whether the clause is a Provision or not i.e. if Y then Provision, if N then Clause.
INSERT_BY_REFERENCE	VARCHAR2	(1)	Yes	Yes/No flag to determine the text that will be printed i.e. if Y then clause should be printed without the clause text, if N then the clause text is printed.
LOCK_TEXT	VARCHAR2	(1)	Yes	Yes/No flag to indicate whether the clause text can be modified on a business document ( this flag determines whether user can modify a standard clause to create a non-standard clause).
GLOBAL_YN	VARCHAR2	(1)		Yes/No flag to indicate whether the clause is global or not i.e. if Y then Global, if N then Local.
ARTICLE_STATUS	VARCHAR2	(30)		Status of the Clause Version. Foreign Key to lookup_code in FND_LOOKUPS where Lookup_Type = OKC_ARTICLE_STATUS. Please use lookup code exactly not meaning.
START_DATE	DATE		Yes	This is the Effective Start Date of the Standard Clause Version.
END_DATE	DATE			This is the Effective End Date of the Standard Clause Version.
DISPLAY_NAME	VARCHAR2	(450)		This is the clause name that will be printed or displayed in a business document. If this column is not populated , the clause title will be used.
ARTICLE_DESCRIPTION	VARCHAR2	(2000)		This is a short description of the Clause Version.
DATE_APPROVED	DATE			User will need to fill this column only if any new or new version of pre-approved clauses are being imported.
DEFAULT_SECTION	VARCHAR2	(30)		Default Section of the Clause. Foreign Key to lookup_code in FND_LOOKUPS where Lookup_Type = OKC_ARTICLE_SECTION. Please use lookup code exactly not meaning.
REFERENCE_SOURCE	VARCHAR2	(150)		This is the reference source of the clause if the Insert By Reference column is Yes e.g. website/publication etc.
REFERENCE_TEXT	VARCHAR2	(2000)		This is the reference text of the clause if the Insert By Reference column is Yes e.g. website/publication etc.
VER_SYSTEM_REFERENCE_CODE	VARCHAR2	(30)		This is used to preserve source of code for clauses to be imported or migrated from external system. Use this if each version's source system is different. Otherwise use ART_SYSTEM_REFERENCE_CODE. User FYI only.
VER_SYSTEM_REFERENCE_ID1	VARCHAR2	(100)		This is used to preserve the identifier1 for clauses migrated or imported from external system. Use this if each version has individual id in external system. Otherwise, use RT_SYSTEM_REFERENCE_ID1. User FYI only.
VER_SYSTEM_REFERENCE_ID2	VARCHAR2	(100)		This is used to preserve the identifier2 for clauses migrated or imported from external system. Use this if each version has individual id in external system. Otherwise, use ART_SYSTEM_REFERENCE_ID2. User FYI only.
ADDITIONAL_INSTRUCTIONS	VARCHAR2	(2000)		This column stores any additional instructions that are needed for using the Clause Version.
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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield category column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column.
DATE_PUBLISHED	DATE			Date the clause was published , specifically used for XML based Clause Import

Query Text

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


SELECT INTERFACE_ID
,      BATCH_NUMBER
,      OBJECT_VERSION_NUMBER
,      ARTICLE_TITLE
,      ORG_ID
,      PROCESS_STATUS
,      ACTION
,      ARTICLE_NUMBER
,      ARTICLE_INTENT
,      ARTICLE_LANGUAGE
,      ARTICLE_TYPE
,      ART_SYSTEM_REFERENCE_CODE
,      ART_SYSTEM_REFERENCE_ID1
,      ART_SYSTEM_REFERENCE_ID2
,      ARTICLE_VERSION_NUMBER
,      ARTICLE_TEXT
,      PROVISION_YN
,      INSERT_BY_REFERENCE
,      LOCK_TEXT
,      GLOBAL_YN
,      ARTICLE_STATUS
,      START_DATE
,      END_DATE
,      DISPLAY_NAME
,      ARTICLE_DESCRIPTION
,      DATE_APPROVED
,      DEFAULT_SECTION
,      REFERENCE_SOURCE
,      REFERENCE_TEXT
,      VER_SYSTEM_REFERENCE_CODE
,      VER_SYSTEM_REFERENCE_ID1
,      VER_SYSTEM_REFERENCE_ID2
,      ADDITIONAL_INSTRUCTIONS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DATE_PUBLISHED
FROM OKC.OKC_ART_INTERFACE_ALL;

Dependencies

[top of page]

OKC.OKC_ART_INTERFACE_ALL does not reference any database object

OKC.OKC_ART_INTERFACE_ALL is referenced by following:

APPS: OKC_ART_INTERFACE; OKC_ART_INTERFACE_ALL