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_PARTIES_T

Object Details

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

OKC_REP_IMP_ERRORS_T is a temporary table for storing an imported contract party's attributes. It is used for validating contract parties, preparing parties data for importing into Contracts Repository schema and generating error messages for invalid parties. 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_PARTIES_T_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	IMP_PARTY_ID
OKC_REP_IMP_PARTIES_T_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
IMP_PARTY_ID	NUMBER		Yes	Unique Import Contract Party ID generated from OKC_REP_IMP_ PARTIES_T_S.
IMP_CONTRACT_ID	NUMBER			Import Contract Id for this party. FK to OKC_REP_IMP_CONTRACTS_T.imp_contract_id.
CONTRACT_ID	NUMBER			PK in OKC_REP_CONTRACTS_ALL
PARTY_INDEX	NUMBER			Index of the party in the CSV file (1 for first, 2 for second, 3 for third)
CONTRACT_PARTY_ID	NUMBER			PK for insertion into production table, generated from sequence OKC_REP_CONTRACT_PARTIES_S.
PARTY_ID	NUMBER			PK of the Party. FK to HR_ALL_ORGANIZATION_UNITS, HZ_PARTIES, or PO_VENDORS, depending on the Party Role.
PARTY_ROLE_CODE	VARCHAR2	(240)		Role of this Party in this Contract. Should be a Party Role in OKC_DEL_RESP_PARTIES_B.resp_party_code.
SIGNED_BY_TXT	VARCHAR2	(151)		Name of the person or persons who signed the contract on behalf of this party
SIGNED_DATE	VARCHAR2	(30)		Date when the contract is signed
PARTY_NAME_TXT	VARCHAR2	(360)		User-entered party name that must exist in either HZ_PARTIES (Customer, Partner), PO_VENDORS (Supplier), or HR_ALL_ORGANIZATION_UNITS (Internal), depending on the Party Role.
PARTY_ROLE_TXT	VARCHAR2	(80)		Party Role of this Party in this Contract. The Party Role must be one of the Party Roles in OKC_DEL_RESP_PARTIES_B.
VALID_FLAG	VARCHAR2	(1)		Used during validation of import data. Indicates if the party is valid: Y if the Party is Valid; N if the Party is Invalid; U if the Party has not been validated yet.
CREATION_DATE	DATE			Standard WHO Column
PROGRAM_ID	NUMBER	(15)		Standard WHO Column.
PROGRAM_LOGIN_ID	NUMBER	(15)		Standard WHO Column
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_PARTY_ID
,      IMP_CONTRACT_ID
,      CONTRACT_ID
,      PARTY_INDEX
,      CONTRACT_PARTY_ID
,      PARTY_ID
,      PARTY_ROLE_CODE
,      SIGNED_BY_TXT
,      SIGNED_DATE
,      PARTY_NAME_TXT
,      PARTY_ROLE_TXT
,      VALID_FLAG
,      CREATION_DATE
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OKC.OKC_REP_IMP_PARTIES_T;

Dependencies

[top of page]

OKC.OKC_REP_IMP_PARTIES_T does not reference any database object

OKC.OKC_REP_IMP_PARTIES_T is referenced by following:

APPS: OKC_REP_IMP_PARTIES_T