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_VARIABLES_INTERFACE

Object Details

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

This is the interface table for import of user defined variables from external systems. All valid data in this table will be imported to OKC_BUS_VARIABLES_A, OKC_BUS_VARIABLES_TL by the XML Based Clause Import Concurrent program. The users are expected to upload data into this table using XML Schema.
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_VARIABLES_INTERFACE_S.NEXTVAL to generate this identifier while loading data into this table.
BATCH_NUMBER	VARCHAR2	(50)	Yes	A system 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.
VARIABLE_CODE	VARCHAR2	(30)	Yes	This is code that is used to identify the variable.
VARIABLE_NAME	VARCHAR2	(150)	Yes	This is the translatable name of the variable. The variable name enclosed in tags is embedded in the clause text.
LANGUAGE	VARCHAR2	(4)	Yes	Language in which variable is created
DESCRIPTION	VARCHAR2	(450)		This is a short description of the variable.
PROCESS_STATUS	VARCHAR2	(1)		Status of the imported Variable, 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' - Sync the variable in the system. 'D' - Disable an existing Variable .
VARIABLE_TYPE	VARCHAR2	(1)	Yes	This defines the type of the variable. The valid values are S=System, U=User Defined, T=Table, D=Deliverable. For XML Based Clause Import , only U is supported.
VARIABLE_INTENT	VARCHAR2	(1)	Yes	This defines the Intent of the variable i.e. Buy or Sell. Foreign Key to FND_LOOKUPS of lookup_type OKC_ARTICLE_INTENT.
CONTRACT_EXPERT_YN	VARCHAR2	(1)		Yes/No flag to indicate whether this is being used in Contract Expert or not.
XPRT_VALUE_SET_NAME	VARCHAR2	(60)		Primary source for the contract expert enabled variable values
DISABLED_YN	VARCHAR2	(1)	Yes	Yes/No flag to indicate whether this variable can no longer be used.
EXTERNAL_YN	VARCHAR2	(1)	Yes	Yes/No flag to indicate whether this variable can be updated by external users or not e.g. supplier.
VARIABLE_DATATYPE	VARCHAR2	(1)		This is the Variable Datatype (D= Date, N=Number, V=Varchar2).
APPLICATION_ID	NUMBER			This column references the owning application in the case of system variables. This is a foreign Key to FND_APPLICATION.
VALUE_SET_NAME	VARCHAR2	(60)		This defines the source of the user-defined variable value. This is mandatory for user-defined variables. Foreign Key to FND FLEX Value Sets.
VARIABLE_DEFAULT_VALUE	VARCHAR2	(30)		This is the Variable Datatype (D= Date, N=Number, V=Varchar2).
ORIG_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.
ORIG_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.
ORIG_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.
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 variable 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
,      VARIABLE_CODE
,      VARIABLE_NAME
,      LANGUAGE
,      DESCRIPTION
,      PROCESS_STATUS
,      ACTION
,      VARIABLE_TYPE
,      VARIABLE_INTENT
,      CONTRACT_EXPERT_YN
,      XPRT_VALUE_SET_NAME
,      DISABLED_YN
,      EXTERNAL_YN
,      VARIABLE_DATATYPE
,      APPLICATION_ID
,      VALUE_SET_NAME
,      VARIABLE_DEFAULT_VALUE
,      ORIG_SYSTEM_REFERENCE_CODE
,      ORIG_SYSTEM_REFERENCE_ID1
,      ORIG_SYSTEM_REFERENCE_ID2
,      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_VARIABLES_INTERFACE;

Dependencies

[top of page]

OKC.OKC_VARIABLES_INTERFACE does not reference any database object

OKC.OKC_VARIABLES_INTERFACE is referenced by following:

APPS: OKC_VARIABLES_INTERFACE