[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKC_SECTIONS_BH |
|---|---|
| Object Type: | TABLE |
| Owner: | OKC |
| FND Design Data: |  OKC.OKC_SECTIONS_BH
|
| Subobject Name: | |
| Status: | VALID |
The formatting of a contract consists of a series of sections. These sections generally have a heading and may have a label, such as "I. Definitions" or "V. Indemnity, Warranties, and Remedies". Sections may have sub-sections.
Sections are composed of articles or lines.
Sections may also be used to format standard article sets. In this case, the section contents are standard articles.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OKC_SECTIONS_BH_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ID
MAJOR_VERSION
|
| OKC_SECTIONS_BH_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CHR_ID
SAT_CODE
SCN_ID
SECTION_SEQUENCE
MAJOR_VERSION
|
| OKC_SECTIONS_BH_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DOCUMENT_TYPE
DOCUMENT_ID
MAJOR_VERSION
SCN_ID
SECTION_SEQUENCE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID | NUMBER | Yes | Primary key column. | |
| MAJOR_VERSION | NUMBER | (4) | Yes | The version of the contract for this history record. |
| SCN_TYPE | VARCHAR2 | (3) | Indicates if the section refers to a contract header or a standard article set. | |
| CHR_ID | NUMBER | Contract header id for this section. If -99, then the section refers to a standard article set. | ||
| SAT_CODE | VARCHAR2 | (30) | Standard Article Set code, for formatting standard article sets. If -99, then this section refers to a contract. | |
| SECTION_SEQUENCE | NUMBER | Sequence number for the section | ||
| 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. |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
| CREATION_DATE | DATE | Yes | Standard Who column. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
| LABEL | VARCHAR2 | (60) | The label to be printed for the section, such as III. or 3. | |
| SCN_ID | NUMBER | Indicates parent section for this subsection | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
| ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| OLD_ID | NUMBER | Keeps earlier 40 digit ID column value before 11.5.10 contract terms changes | ||
| DOCUMENT_TYPE | VARCHAR2 | (30) | Yes | Document type. foreign key to okc_bus_doc_types_bh |
| DOCUMENT_ID | NUMBER | Yes | Business document identifier. Foreign key to various business document header tables | |
| SCN_CODE | VARCHAR2 | (30) | section identifier | |
| DESCRIPTION | VARCHAR2 | (2000) | Description | |
| AMENDMENT_DESCRIPTION | VARCHAR2 | (2000) | Text to capture amendment description at section level | |
| AMENDMENT_OPERATION_CODE | VARCHAR2 | (30) | Amendment opration performed for the section. Allowed operations are INSERT, CHANGE, DELETE | |
| ORIG_SYSTEM_REFERENCE_CODE | VARCHAR2 | (30) | This will preserve the code for migrated systems such as FAR, OKCMIGR | |
| ORIG_SYSTEM_REFERENCE_ID1 | NUMBER | This will preserve id for migrated systems | ||
| ORIG_SYSTEM_REFERENCE_ID2 | NUMBER | This will preserve id for migrated systems | ||
| PRINT_YN | VARCHAR2 | (1) | Flag to indicate to print the section | |
| SUMMARY_AMEND_OPERATION_CODE | VARCHAR2 | (30) | Amendment opration performed for the section. Allowed operations are INSERT, CHANGE, DELETE | |
| HEADING | VARCHAR2 | (300) | Section title. This column is migrated from okc_sections_tlh table | |
| LAST_AMENDED_BY | NUMBER | |||
| LAST_AMENDMENT_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, MAJOR_VERSION
, SCN_TYPE
, CHR_ID
, SAT_CODE
, SECTION_SEQUENCE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LABEL
, SCN_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, OLD_ID
, DOCUMENT_TYPE
, DOCUMENT_ID
, SCN_CODE
, DESCRIPTION
, AMENDMENT_DESCRIPTION
, AMENDMENT_OPERATION_CODE
, ORIG_SYSTEM_REFERENCE_CODE
, ORIG_SYSTEM_REFERENCE_ID1
, ORIG_SYSTEM_REFERENCE_ID2
, PRINT_YN
, SUMMARY_AMEND_OPERATION_CODE
, HEADING
, LAST_AMENDED_BY
, LAST_AMENDMENT_DATE
FROM OKC.OKC_SECTIONS_BH;
OKC.OKC_SECTIONS_BH does not reference any database object
OKC.OKC_SECTIONS_BH is referenced by following:
OKC
OKC_SECTIONS_BH#
|
|
|
|