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_IMP_CONTRACTS_T

Object Details

Object Name:	OKC_REP_IMP_CONTRACTS_T
Object Type:	TABLE
Owner:	OKC
Subobject Name:
Status:	VALID

OKC_REP_IMP_CONTRACTS_T is a temporary table for storing imported contract header attributes. It is used for validating contract attributes, preparing contract header data for importing into Contracts Repository schema and generating error output file for invalid contracts. The data is deleted after each Import process.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_REP_IMP_CONTRACTS_T_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	IMP_CONTRACT_ID
OKC_REP_IMP_CONTRACTS_T_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
IMP_CONTRACT_ID	NUMBER		Yes	Unique import contract ID generated from OKC_REP_IMP_CONTRACTS_S.
CONTRACT_ID	NUMBER			PK in OKC_REP_CONTRACTS_ALL
CONTRACT_NUMBER	VARCHAR2	(151)		User-entered or auto-generated identifier for the contract based on a profile option.
CONTRACT_NAME	VARCHAR2	(451)		User-entered name for the Contract.
DESCRIPTION	VARCHAR2	(2001)		Description of the contract.
CONTRACT_TYPE	VARCHAR2	(30)		User-defined Contract Type from OKC_BUS_DOC_TYPES_B.document_type.
AUTHORING_PARTY_CODE	VARCHAR2	(30)		Specifies whether an internal org or an external party authors this contract. I (Internal), E (External) from LOOKUP_TYPE OKC_AUTHORING_PARTY.
CONTRACT_STATUS_CODE	VARCHAR2	(30)		Current status of the contract from LOOKUP_TYPE OKC_REP_CONTRACT_STATUSES.
VERSION_COMMENTS	VARCHAR2	(2001)		User comments for this version of contract.
CONTRACT_EFFECTIVE_DATE	VARCHAR2	(30)		Effective Date of Contract.
CONTRACT_EXPIRATION_DATE	VARCHAR2	(30)		Expiration Date of Contract.
CURRENCY_CODE	VARCHAR2	(15)		Currency in which the amounts in this contract is transacted. Should be one of the currency codes defined in FND_CURRENCIES.currency_code.
CONTRACT_AMOUNT	VARCHAR2	(30)		The Amount of this Contract.
ORG_NAME	VARCHAR2	(240)		Operating Unit to which this Contract belongs. Should be one of the organizations defined in HR_ALL_ORGANIZATION_UNITS.
ORG_ID	NUMBER	(15)		Organization ID of the Operating Unit to which this Contract belongs.
OWNER_USER_NAME	VARCHAR2	(100)		FND User Name of the Owner of the Contract.
OWNER_USER_ID	NUMBER	(15)		FND_USER.USER_ID of the Owner (OWNER_USER_NAME) of the Contract.
PHYSICAL_LOCATION	VARCHAR2	(2001)		User-entered physical location of the contract
KEYWORDS	VARCHAR2	(2001)		User-entered keywords of this Contract.
CONTRACT_TYPE_TXT	VARCHAR2	(150)		OKC_BUS_DOC_TYPES_TL.name.
AUTHORING_PARTY_TXT	VARCHAR2	(80)		Authoring Party from LOOKUP_TYPE OKC_AUTHORING_PARTY (Meaning).
CONTRACT_STATUS_TXT	VARCHAR2	(80)		Current status of the contract from LOOKUP_TYPE OKC_REP_CONTRACT_STATUSES (Meaning).
VALID_FLAG	VARCHAR2	(1)		Used during validation of import data. Indicates if the contract is valid: Y if the Contract is Valid; N if the Contract is Invalid; U if the Contract has not been validated yet.
ORIG_SYSTEM_REFERENCE_CODE	VARCHAR2	(31)		The original code for contracts migrated from external systems
ORIG_SYSTEM_REFERENCE_ID1	VARCHAR2	(101)		The original ID for contracts migrated from external systems
ORIG_SYSTEM_REFERENCE_ID2	VARCHAR2	(101)		The original ID for contracts migrated from external systems
CREATION_DATE	DATE			Standard WHO column.
PROGRAM_ID	NUMBER	(15)		Identifies the concurrent program. Populated from FND_GLOBAL.conc_program_id.
PROGRAM_LOGIN_ID	NUMBER	(15)		Identifies the Login ID of the user from FND_GLOBAL.conc_login_id
PROGRAM_APPLICATION_ID	NUMBER	(15)		fnd_global.prog_appl_id
REQUEST_ID	NUMBER	(15)		Identifies the concurrent request instance that spawned the concurrent program from FND_GLOBAL.conc_request_id.

Query Text

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


SELECT IMP_CONTRACT_ID
,      CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_NAME
,      DESCRIPTION
,      CONTRACT_TYPE
,      AUTHORING_PARTY_CODE
,      CONTRACT_STATUS_CODE
,      VERSION_COMMENTS
,      CONTRACT_EFFECTIVE_DATE
,      CONTRACT_EXPIRATION_DATE
,      CURRENCY_CODE
,      CONTRACT_AMOUNT
,      ORG_NAME
,      ORG_ID
,      OWNER_USER_NAME
,      OWNER_USER_ID
,      PHYSICAL_LOCATION
,      KEYWORDS
,      CONTRACT_TYPE_TXT
,      AUTHORING_PARTY_TXT
,      CONTRACT_STATUS_TXT
,      VALID_FLAG
,      ORIG_SYSTEM_REFERENCE_CODE
,      ORIG_SYSTEM_REFERENCE_ID1
,      ORIG_SYSTEM_REFERENCE_ID2
,      CREATION_DATE
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OKC.OKC_REP_IMP_CONTRACTS_T;

Dependencies

[top of page]

OKC.OKC_REP_IMP_CONTRACTS_T does not reference any database object

OKC.OKC_REP_IMP_CONTRACTS_T is referenced by following:

APPS: OKC_REP_IMP_CONTRACTS_T