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