[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:
|
|
|