eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKC.OKC_REP_CONTRACTS_ALL

Object Details

Object Name:	OKC_REP_CONTRACTS_ALL
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_REP_CONTRACTS_ALL
Subobject Name:
Status:	VALID

OKC_REP_CONTRACTS_ALL is the main Contracts table. This table stores the latest version of all contracts authored in Contract Repository.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_REP_CONTRACTS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTRACT_ID
OKC_REP_CONTRACTS_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTRACT_NUMBER
OKC_REP_CONTRACTS_ALL_CTX	DOMAIN	NONUNIQUE		KEYWORDS
OKC_REP_CONTRACTS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AMOUNT
OKC_REP_CONTRACTS_ALL_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_ID
OKC_REP_CONTRACTS_ALL_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OVERALL_RISK_CODE
OKC_REP_CONTRACTS_ALL_N12	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("CONTRACT_NUMBER")
OKC_REP_CONTRACTS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTRACT_TYPE
OKC_REP_CONTRACTS_ALL_N4	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("CONTRACT_NAME")
OKC_REP_CONTRACTS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTRACT_EFFECTIVE_DATE
OKC_REP_CONTRACTS_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_CODE
OKC_REP_CONTRACTS_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTRACT_EXPIRATION_DATE
OKC_REP_CONTRACTS_ALL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERMINATION_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRACT_ID	NUMBER		Yes	Identifier of the contract. Sourced from sequence OKC_REPO_CONTRACTS_ALL_S
CONTRACT_VERSION_NUM	NUMBER		Yes	Auto-generated version for the contract. Starts at 1 and incremented by 1 for each new version.
CONTRACT_NAME	VARCHAR2	(450)		User-entered name of the contract.
CONTRACT_NUMBER	VARCHAR2	(150)	Yes	Contract number. User entered or automatically generated, depending on a profile
CONTRACT_DESC	VARCHAR2	(2000)		Description of the contract.
CONTRACT_TYPE	VARCHAR2	(30)	Yes	Type of the contract (user-defined).
CONTRACT_STATUS_CODE	VARCHAR2	(30)	Yes	Lookup code of the current status of the contract. Taken from lookup type OKC_REP_CONTRACT_STATUSES.
LATEST_SIGNED_VER_NUMBER	NUMBER			Version of the latest 'Signed' contract
VERSION_COMMENTS	VARCHAR2	(2000)		User comments for this version of the contract.
ORG_ID	NUMBER		Yes	Internal Operating unit to which this contract belongs.
AUTHORING_PARTY_CODE	VARCHAR2	(30)		Whether this contract is authored internally or by an external party. Valid values are Internal, External.
OWNER_ID	NUMBER		Yes	User ID of the owner of the contract. Defaulted to the creator of the contract.
CONTRACT_EFFECTIVE_DATE	DATE			Date from which the contract is effective.
CONTRACT_EXPIRATION_DATE	DATE			Date the contract expires.
CURRENCY_CODE	VARCHAR2	(15)		Currency in which the amounts in this contract is transacted.
AMOUNT	NUMBER			The total amount transacted in this contract.
OVERALL_RISK_CODE	VARCHAR2	(30)		Overall risk level of the contract
CANCELLATION_COMMENTS	VARCHAR2	(2000)		Cancellation user comments.
CANCELLATION_DATE	DATE			Date on which the contract was cancelled.
TERMINATION_COMMENTS	VARCHAR2	(2000)		Termination user comments.
TERMINATION_DATE	DATE			Date on which the contract was terminated.
KEYWORDS	VARCHAR2	(2000)		User-entered keywords of a contract. Used mainly in Search.
PHYSICAL_LOCATION	VARCHAR2	(2000)		Description of the physical location of the contract document.
EXPIRE_NTF_FLAG	VARCHAR2	(1)		Flag to indicate whether to send a contract expiration notification. Valid values are 'Y' and 'N'.
EXPIRE_NTF_PERIOD	NUMBER			Number representing the period before which the expiration notification will be sent.
NOTIFY_CONTACT_ROLE_ID	NUMBER			Contact Role to whom the expiration notification is sent.
WF_EXP_NTF_ITEM_KEY	VARCHAR2	(240)		Workflow item key for Expiration notification.
ORIG_SYSTEM_REFERENCE_CODE	VARCHAR2	(30)		The original code for contracts migrated from external systems
ORIG_SYSTEM_REFERENCE_ID1	VARCHAR2	(100)		The original ID for contracts migrated from external systems
ORIG_SYSTEM_REFERENCE_ID2	VARCHAR2	(100)		The original ID for contracts migrated from external systems
USE_ACL_FLAG	VARCHAR2	(1)		Flag to indicate whether to use the access control list for finer security on the contract.
WF_ITEM_TYPE	VARCHAR2	(8)		Type of the Workflow process initiated.
WF_ITEM_KEY	VARCHAR2	(240)		Id of the Workflow approval process initiated. From sequence OKC_REP_APPROVAL_WF_S.
CONTRACT_LAST_UPDATED_BY	NUMBER	(15)		USER ID of the user who last updated the contract business object. This column is updated whenever any part of the contract is modified (e.g. parties, contacts, acl, etc). Used in Recent Contracts table.
CONTRACT_LAST_UPDATE_DATE	DATE			Date in which the contract business object was last updated. This date is updated whenever any part of the contract is modified (e.g. parties, contacts, acl, etc). Used in Recent Contracts table.
SOURCE_LANGUAGE	VARCHAR2	(4)	Yes	Original language in which this contract was created.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Sequential number set at 1on 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.
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.
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.
REFERENCE_DOCUMENT_TYPE	VARCHAR2	(30)
REFERENCE_DOCUMENT_NUMBER	VARCHAR2	(150)
REFERENCE_DOCUMENT_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CONTRACT_ID
,      CONTRACT_VERSION_NUM
,      CONTRACT_NAME
,      CONTRACT_NUMBER
,      CONTRACT_DESC
,      CONTRACT_TYPE
,      CONTRACT_STATUS_CODE
,      LATEST_SIGNED_VER_NUMBER
,      VERSION_COMMENTS
,      ORG_ID
,      AUTHORING_PARTY_CODE
,      OWNER_ID
,      CONTRACT_EFFECTIVE_DATE
,      CONTRACT_EXPIRATION_DATE
,      CURRENCY_CODE
,      AMOUNT
,      OVERALL_RISK_CODE
,      CANCELLATION_COMMENTS
,      CANCELLATION_DATE
,      TERMINATION_COMMENTS
,      TERMINATION_DATE
,      KEYWORDS
,      PHYSICAL_LOCATION
,      EXPIRE_NTF_FLAG
,      EXPIRE_NTF_PERIOD
,      NOTIFY_CONTACT_ROLE_ID
,      WF_EXP_NTF_ITEM_KEY
,      ORIG_SYSTEM_REFERENCE_CODE
,      ORIG_SYSTEM_REFERENCE_ID1
,      ORIG_SYSTEM_REFERENCE_ID2
,      USE_ACL_FLAG
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      CONTRACT_LAST_UPDATED_BY
,      CONTRACT_LAST_UPDATE_DATE
,      SOURCE_LANGUAGE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      REFERENCE_DOCUMENT_TYPE
,      REFERENCE_DOCUMENT_NUMBER
,      REFERENCE_DOCUMENT_ID
FROM OKC.OKC_REP_CONTRACTS_ALL;

Dependencies

[top of page]

OKC.OKC_REP_CONTRACTS_ALL does not reference any database object

OKC.OKC_REP_CONTRACTS_ALL is referenced by following:

APPS: OKC_REP_CONTRACTS; OKC_REP_CONTRACTS_ALL