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_H

Object Details

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

This entity will contain relationship between template and document where it is used. (history records)

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000329380C00022$$	LOB	UNIQUE	APPS_TS_TX_DATA
OKC_TEMPLATE_USAGES_H_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID
OKC_TEMPLATE_USAGES_H_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_TYPE DOCUMENT_ID MAJOR_VERSION

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
MAJOR_VERSION	NUMBER		Yes	Major version
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			Configuration header id created for the Document in Configurator
CONFIG_REVISION_NUMBER	NUMBER			Configuration revision number corresponding to the Configuration header id
VALID_CONFIG_YN	VARCHAR2	(1)		Valid configuration indicator
ORIG_SYSTEM_REFERENCE_CODE	VARCHAR2	(30)		Original system reference code
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)		Indicates which party of the contract was the author of the contract terms. Valid values are INTERNAL, CUSTOMER, SUPPLIER. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE=OKC_AUTHORING_PARTY_TYPES
CONTRACT_SOURCE_CODE	VARCHAR2	(30)		Indicates the current source of contract terms for the business document. Valid values are STRUCTURED, ATTACHED, NONE. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE=OKC_CONTRACT_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
LEGAL_CONTACT_ID	NUMBER
LOCK_TERMS_FLAG	VARCHAR2	(1)
ENABLE_REPORTING_FLAG	VARCHAR2	(1)
LOCKED_BY_USER_ID	NUMBER

Query Text

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


SELECT DOCUMENT_TYPE
,      DOCUMENT_ID
,      TEMPLATE_ID
,      MAJOR_VERSION
,      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_H;

Dependencies

[top of page]

OKC.OKC_TEMPLATE_USAGES_H does not reference any database object

OKC.OKC_TEMPLATE_USAGES_H is referenced by following:

APPS: OKC_TEMPLATE_USAGES_H