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_DOCUMENTS_T

Object Details

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

OKC_REP_IMP_DOCUMENTS_T is a temporary table for storing imported Contract Documents attributes. It is used for validating Contract Documents and generating error messages for invalid records. 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_DOCUMENTS_T_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	IMP_DOCUMENT_ID
OKC_REP_IMP_DOCUMENTS_T_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
IMP_DOCUMENT_ID	NUMBER		Yes	Unique Import Document ID from OKC_REP_IMP_ DOCUMENTS_T_S.
IMP_CONTRACT_ID	NUMBER			Import Contract Id for this Contract Document. FK to OKC_REP_IMP_CONTRACTS_T.imp_contract_id.
CONTRACT_ID	NUMBER			PK in OKC_REP_CONTRACTS_ALL
DOCUMENT_INDEX	NUMBER			Index of the document in CSV template (1 for first, 2 for second, etc)
CATEGORY_CODE	VARCHAR2	(30)		One of category types defined in FND_DOCUMENT_CATEGORIES
FILE_TYPE_MEANING	VARCHAR2	(81)		File Type of the current record. Allowed values are File or Web Address.
FILE_NAME	VARCHAR2	(2049)		Full path to the physical file containing this document.
DOCUMENT_DESC	VARCHAR2	(256)		User description of this document.
FILE_TYPE_CODE	VARCHAR2	(30)		File Type lookup code of the current record. Allowed values are FILE or WEB_ADDRESS.
CATEGORY_NAME_TXT	VARCHAR2	(240)		Name of the Document Category to which the file belongs.
VALID_FLAG	VARCHAR2	(1)		Used during validation of import data. Indicates if the Contract Document is valid: Y if it is Valid; N if it is Invalid; U if it 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_DOCUMENT_ID
,      IMP_CONTRACT_ID
,      CONTRACT_ID
,      DOCUMENT_INDEX
,      CATEGORY_CODE
,      FILE_TYPE_MEANING
,      FILE_NAME
,      DOCUMENT_DESC
,      FILE_TYPE_CODE
,      CATEGORY_NAME_TXT
,      VALID_FLAG
,      CREATION_DATE
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OKC.OKC_REP_IMP_DOCUMENTS_T;

Dependencies

[top of page]

OKC.OKC_REP_IMP_DOCUMENTS_T does not reference any database object

OKC.OKC_REP_IMP_DOCUMENTS_T is referenced by following:

APPS: OKC_REP_IMP_DOCUMENTS_T