[Home] [Help] [Dependency Information]
Object Name: | OKC_CONTRACT_DOCS |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_CONTRACT_DOCS |
Subobject Name: | |
Status: | VALID |
This intermediate table is used by Contract Documents to store Business Document attachments entries. The actual attachments are store in FND Attachment schema. The table also has extra columns (Effective_Version_from and External Visiblity) that are not available in FND Attachments tables.The table uses Effective_Version_From column to Version Business Document attachments by reference.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_CONTRACTS_DOCS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BUSINESS_DOCUMENT_TYPE
BUSINESS_DOCUMENT_ID BUSINESS_DOCUMENT_VERSION ATTACHED_DOCUMENT_ID |
OKC_CONTRACT_DOCS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BUSINESS_DOCUMENT_VERSION
BUSINESS_DOCUMENT_TYPE BUSINESS_DOCUMENT_ID ATTACHED_DOCUMENT_ID |
OKC_CONTRACT_DOCS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BUSINESS_DOCUMENT_TYPE
BUSINESS_DOCUMENT_ID BUSINESS_DOCUMENT_VERSION DELETE_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_DOCUMENT_TYPE | VARCHAR2 | (30) | Yes | Foreign key to OKC_BUS_DOC_TYPES |
BUSINESS_DOCUMENT_ID | NUMBER | Yes | Business document unique identifier | |
BUSINESS_DOCUMENT_VERSION | NUMBER | Yes | Business document version | |
ATTACHED_DOCUMENT_ID | NUMBER | Yes | Foreign key to FND_ATTACHED_DOCUMENTS | |
EXTERNAL_VISIBILITY_FLAG | VARCHAR2 | (1) | Yes | For future use |
EFFECTIVE_FROM_TYPE | VARCHAR2 | (30) | Yes | Document type for reference document. |
EFFECTIVE_FROM_ID | NUMBER | Yes | Document Identifier for the Reference document. | |
EFFECTIVE_FROM_VERSION | NUMBER | Yes | Version from which the document is referenced. | |
PARENT_ATTACHED_DOC_ID | NUMBER | Document Identifier for the Parent Document. | ||
INCLUDE_FOR_APPROVAL_FLAG | VARCHAR2 | (1) | Yes | Indicates whether this document should be included in approval |
GENERATED_FLAG | VARCHAR2 | (1) | Indicates whether this document is auto generated. | |
DELETE_FLAG | VARCHAR2 | (1) | Indicates whether this document is deleted. | |
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. | |
PROGRAM_ID | NUMBER | Standard Who column. | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column. | ||
REQUEST_ID | NUMBER | Standard Who column. | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column. | ||
PRIMARY_CONTRACT_DOC_FLAG | VARCHAR2 | (1) | Indicates whether this document is the Primary Contract Document containing the Contract Terms when the Contract Source is set to Attached Document. This document will be used in lieu of structured contract terms. | |
MERGEABLE_DOC_FLAG | VARCHAR2 | (1) | Indicates whether this document is mergeable during preview of business document. |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_DOCUMENT_TYPE
, BUSINESS_DOCUMENT_ID
, BUSINESS_DOCUMENT_VERSION
, ATTACHED_DOCUMENT_ID
, EXTERNAL_VISIBILITY_FLAG
, EFFECTIVE_FROM_TYPE
, EFFECTIVE_FROM_ID
, EFFECTIVE_FROM_VERSION
, PARENT_ATTACHED_DOC_ID
, INCLUDE_FOR_APPROVAL_FLAG
, GENERATED_FLAG
, DELETE_FLAG
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
, PROGRAM_UPDATE_DATE
, PRIMARY_CONTRACT_DOC_FLAG
, MERGEABLE_DOC_FLAG
FROM OKC.OKC_CONTRACT_DOCS;
OKC.OKC_CONTRACT_DOCS does not reference any database object
OKC.OKC_CONTRACT_DOCS is referenced by following:
|
|
|