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_TEMPLATE_USAGES

Object Details

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

This entity will contain relationship between template and document where it is used.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000329369C00021$$	LOB	UNIQUE	APPS_TS_TX_DATA
OKC_TEMPLATE_USAGES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID
OKC_TEMPLATE_USAGES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOC_NUMBERING_SCHEME
OKC_TEMPLATE_USAGES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTRACT_ADMIN_ID
OKC_TEMPLATE_USAGES_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_TYPE DOCUMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Business document type. Foreign key to okc_bus_doc_types_b
DOCUMENT_ID	NUMBER		Yes	Business document header id. Foreign key to various business document header tables
TEMPLATE_ID	NUMBER			Template used. Foreign key to okc_terms_templates_all
DOC_NUMBERING_SCHEME	NUMBER			Numbering scheme used in a document
DOCUMENT_NUMBER	VARCHAR2	(150)		Business Document number
ARTICLE_EFFECTIVE_DATE	DATE			Clause effectivity date
CONFIG_HEADER_ID	NUMBER			Header id for the contract expert configurator
CONFIG_REVISION_NUMBER	NUMBER			Revision number for the contract expert configurator
VALID_CONFIG_YN	VARCHAR2	(1)		Indicator for configuration validity
ORIG_SYSTEM_REFERENCE_CODE	VARCHAR2	(30)		Original system reference code to indicate the original source
ORIG_SYSTEM_REFERENCE_ID1	NUMBER			Original system reference id
ORIG_SYSTEM_REFERENCE_ID2	NUMBER			Original system reference id
LAST_UPDATE_LOGIN	NUMBER			standard who column
CREATION_DATE	DATE		Yes	standard who column
CREATED_BY	NUMBER		Yes	standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	standard who column
LAST_UPDATE_DATE	DATE		Yes	standard who 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.
AUTHORING_PARTY_CODE	VARCHAR2	(30)	Yes	Indicates which party of the contract was the author of the contract terms. Refers to the column OKC_RESP_PARTIES_B.RESP_PARTY_CODE.
CONTRACT_SOURCE_CODE	VARCHAR2	(30)	Yes	Indicates the current source of contract terms for the business document. Valid values are STRUCTURED, ATTACHED. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE=OKC_CONTRACT_TERMS_SOURCES
APPROVAL_ABSTRACT_TEXT	CLOB	(4000)		This is the textual content of the abstract that would be sent as part of deviation report during approval
AUTOGEN_DEVIATIONS_FLAG	VARCHAR2	(1)		Flag to indicate if deviations should be autogenerated for this business document.
SOURCE_CHANGE_ALLOWED_FLAG	VARCHAR2	(1)		This flag is used to determine if contract source is allowed to be changed.
CONTRACT_ADMIN_ID	NUMBER			ID of the Contract Administrator. This is the Person_Id from the PER_ALL_PEOPLE table
LEGAL_CONTACT_ID	NUMBER			ID of the Legal Contact. This is the Person_Id from the Per_All_People table
LOCK_TERMS_FLAG	VARCHAR2	(1)		Flag to indicate if the structured Terms are locked
ENABLE_REPORTING_FLAG	VARCHAR2	(1)		Flag to indicate if the Structured Terms are to be used when the Contracts Terms are represented as Attached Document
LOCKED_BY_USER_ID	NUMBER			User_Id of the user locking the structured contract terms

Query Text

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


SELECT DOCUMENT_TYPE
,      DOCUMENT_ID
,      TEMPLATE_ID
,      DOC_NUMBERING_SCHEME
,      DOCUMENT_NUMBER
,      ARTICLE_EFFECTIVE_DATE
,      CONFIG_HEADER_ID
,      CONFIG_REVISION_NUMBER
,      VALID_CONFIG_YN
,      ORIG_SYSTEM_REFERENCE_CODE
,      ORIG_SYSTEM_REFERENCE_ID1
,      ORIG_SYSTEM_REFERENCE_ID2
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      AUTHORING_PARTY_CODE
,      CONTRACT_SOURCE_CODE
,      APPROVAL_ABSTRACT_TEXT
,      AUTOGEN_DEVIATIONS_FLAG
,      SOURCE_CHANGE_ALLOWED_FLAG
,      CONTRACT_ADMIN_ID
,      LEGAL_CONTACT_ID
,      LOCK_TERMS_FLAG
,      ENABLE_REPORTING_FLAG
,      LOCKED_BY_USER_ID
FROM OKC.OKC_TEMPLATE_USAGES;

Dependencies

[top of page]

OKC.OKC_TEMPLATE_USAGES does not reference any database object

OKC.OKC_TEMPLATE_USAGES is referenced by following:

APPS: OKC_TEMPLATE_USAGES