[Home] [Help] [Dependency Information]
Object Name: | OKC_REP_SIGNATURE_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | OKC |
Subobject Name: | |
Status: | VALID |
OKC_REP_SIGNATURE_DETAILS table stores the Signature details of a Contract Party.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_REP_SIGNATURE_DETAILS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CONTRACT_ID
CONTRACT_VERSION_NUM PARTY_ROLE_CODE PARTY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_ID | NUMBER | Yes | Contract ID column | |
CONTRACT_VERSION_NUM | NUMBER | Yes | Contract version number | |
PARTY_ROLE_CODE | VARCHAR2 | (30) | Yes | Role code of the signing party |
PARTY_ID | NUMBER | Yes | ID of the signing party | |
SIGNED_BY | VARCHAR2 | (150) | Signed by party contact/user | |
SIGNED_DATE | DATE | Party signature date | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Standard column |
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 | Identifies the concurrent program. | ||
PROGRAM_LOGIN_ID | NUMBER | Identifies the Oracle Applications Concurrent Program Login ID. | ||
PROGRAM_APPLICATION_ID | NUMBER | Identifies the Oracle Application that spawned the concurrent program. | ||
REQUEST_ID | NUMBER | Identifies the concurrent request instance that spawned the concurrent program. |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACT_ID
, CONTRACT_VERSION_NUM
, PARTY_ROLE_CODE
, PARTY_ID
, SIGNED_BY
, SIGNED_DATE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM OKC.OKC_REP_SIGNATURE_DETAILS;
OKC.OKC_REP_SIGNATURE_DETAILS does not reference any database object
OKC.OKC_REP_SIGNATURE_DETAILS is referenced by following:
|
|
|