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_TERMS_TEMPLATES_ALL

Object Details

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

OKC_TERMS_TEMPLATES_ALL stores the all contract templates and its related information. This has geneal information like Name, Start Date, End Date, Intent

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_TERMS_TEMPLATES_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID
OKC_TERMS_TEMPLATES_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_ID TEMPLATE_NAME WORKING_COPY_FLAG
OKC_TERMS_TEMPLATES_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_NAME
OKC_TERMS_TEMPLATES_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRINT_TEMPLATE_ID
OKC_TERMS_TEMPLATES_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TEMPLATE_ID
OKC_TERMS_TEMPLATES_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TMPL_NUMBERING_SCHEME
OKC_TERMS_TEMPLATES_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_DATE
OKC_TERMS_TEMPLATES_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE
OKC_TERMS_TEMPLATES_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	XPRT_REQUEST_ID
OKC_TERMS_TEMPLATES_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSLATED_FROM_TMPL_ID
OKC_TERMS_TEMPLATES_CTX	DOMAIN	NONUNIQUE		TEMPLATE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_ID	NUMBER		Yes	Unique Identifier for the Contract Template. Primary key column for the template table
TEMPLATE_NAME	VARCHAR2	(240)	Yes	Name of the Contract Template.
INTENT	VARCHAR2	(1)	Yes	Intent of the Contract Template. Possible values are B Buy or S Sell
STATUS_CODE	VARCHAR2	(30)	Yes	Status of the Contract Template . Possible values are DRAFT, APPROVED, ON HOLD, PENDING_APPROVAL, REJECTED and REVISION
START_DATE	DATE		Yes	Date from which the Contract Template is available for use.
END_DATE	DATE			Date after which the Contract Template can no longer be used.
GLOBAL_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if the Contract template is Global or not. Possible values are Y and N.
INSTRUCTION_TEXT	VARCHAR2	(2000)		Instructions to use the Contract Template.
DESCRIPTION	VARCHAR2	(2000)		Description of the Contract Template.
WORKING_COPY_FLAG	VARCHAR2	(1)		Flag to indicate if the Contract Template is a Working copy or not. Valid values are Y and N.
PARENT_TEMPLATE_ID	NUMBER			Identifier of the original Contract Template if the current template is a working copy. Refers to the TEMPLATE_ID in OKC_TERMS_TEMPLATES_ALL
CONTRACT_EXPERT_ENABLED	VARCHAR2	(1)	Yes	Flag to indicate whether contract expert can be used once the Contract Template is applied on a business document or not. Possible values are Y and N. For Future Use.
TEMPLATE_MODEL_ID	NUMBER			For Future use.
TMPL_NUMBERING_SCHEME	NUMBER			Numbering scheme used on the Contract Template. Refers to the NUMBERING_SCHEME_ID in OKC_NUM_SCHEMES_B
PRINT_TEMPLATE_ID	NUMBER			Print Layout Template used. Refers to the TEMPLATE_ID in XDO_TEMPLATES_B
APPROVAL_WF_KEY	VARCHAR2	(240)		Approval work flow key
CZ_EXPORT_WF_KEY	VARCHAR2	(240)		Contract Expert export workflow key
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		Yes	standard who column
LAST_UPDATE_DATE	DATE		Yes	standard who column
ORG_ID	NUMBER			Identifier of the operating unit that the contract template belongs to.
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
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
HIDE_YN	VARCHAR2	(1)		Flag to indicate if the Contract Template should be hidden from the Contract Terms Library or not. Possible values are Y and N.
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		standard flex field column
ATTRIBUTE1	VARCHAR2	(450)		standard flex field column
ATTRIBUTE2	VARCHAR2	(450)		standard flex field column
ATTRIBUTE3	VARCHAR2	(450)		standard flex field column
ATTRIBUTE4	VARCHAR2	(450)		standard flex field column
ATTRIBUTE5	VARCHAR2	(450)		standard flex field column
ATTRIBUTE6	VARCHAR2	(450)		standard flex field column
ATTRIBUTE7	VARCHAR2	(450)		standard flex field column
ATTRIBUTE8	VARCHAR2	(450)		standard flex field column
ATTRIBUTE9	VARCHAR2	(450)		standard flex field column
ATTRIBUTE10	VARCHAR2	(450)		standard flex field column
ATTRIBUTE11	VARCHAR2	(450)		standard flex field column
ATTRIBUTE12	VARCHAR2	(450)		standard flex field column
ATTRIBUTE13	VARCHAR2	(450)		standard flex field column
ATTRIBUTE14	VARCHAR2	(450)		standard flex field column
ATTRIBUTE15	VARCHAR2	(450)		standard flex field column
XPRT_REQUEST_ID	NUMBER			Concurrent request id of the rules publication program.
XPRT_CLAUSE_MANDATORY_FLAG	VARCHAR2	(1)		Flag to indicate whether the clauses brought for into a business document by expert are mandatory or not
XPRT_SCN_CODE	VARCHAR2	(30)		Contract expert default section
LANGUAGE	VARCHAR2	(4)		Language of the current template
TRANSLATED_FROM_TMPL_ID	NUMBER			Template ID of the template from which the current template has been translated.
CLS_ENABLED	VARCHAR2	(1)

Query Text

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


SELECT TEMPLATE_ID
,      TEMPLATE_NAME
,      INTENT
,      STATUS_CODE
,      START_DATE
,      END_DATE
,      GLOBAL_FLAG
,      INSTRUCTION_TEXT
,      DESCRIPTION
,      WORKING_COPY_FLAG
,      PARENT_TEMPLATE_ID
,      CONTRACT_EXPERT_ENABLED
,      TEMPLATE_MODEL_ID
,      TMPL_NUMBERING_SCHEME
,      PRINT_TEMPLATE_ID
,      APPROVAL_WF_KEY
,      CZ_EXPORT_WF_KEY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      ORG_ID
,      ORIG_SYSTEM_REFERENCE_CODE
,      ORIG_SYSTEM_REFERENCE_ID1
,      ORIG_SYSTEM_REFERENCE_ID2
,      OBJECT_VERSION_NUMBER
,      HIDE_YN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      XPRT_REQUEST_ID
,      XPRT_CLAUSE_MANDATORY_FLAG
,      XPRT_SCN_CODE
,      LANGUAGE
,      TRANSLATED_FROM_TMPL_ID
,      CLS_ENABLED
FROM OKC.OKC_TERMS_TEMPLATES_ALL;

Dependencies

[top of page]

OKC.OKC_TERMS_TEMPLATES_ALL does not reference any database object

OKC.OKC_TERMS_TEMPLATES_ALL is referenced by following:

OKC: OKC_TERMS_TEMPLATES_ALL#