[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
OKC.OKC_TEMPLATE_USAGES does not reference any database object
OKC.OKC_TEMPLATE_USAGES is referenced by following:
|
|
|