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: ICX.ICX_CAT_CONVERTER_DETAILS

Object Details

Object Name:	ICX_CAT_CONVERTER_DETAILS
Object Type:	TABLE
Owner:	ICX
Subobject Name:
Status:	VALID

This table stores the details of the converted R12 files. This table is needed because the relationship of 11.5.10 files and R12 files is one to many. The column file_name is used for naming the generated R12 files, all of which have names in the format of X_<11.5.10 file name>, where X is either a sequential number (for data file) or 'schema' for (schema file).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000401959C00009$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
FILE_ID	NUMBER		Yes	File ID of the converted R12 file
FILE_NAME	VARCHAR2	(240)	Yes	File name of the converted R12 file
SUPPLIER_NAME	VARCHAR2	(240)		Supplier Name
SUPPLIER_SITE	VARCHAR2	(240)		Supplier Site
OPERATING_UNIT	VARCHAR2	(240)		Operating Unit
CURRENCY_CODE	VARCHAR2	(4)		Currency Code
CONTRACT_NUMBER	VARCHAR2	(20)		Contract Number
FILE_ENCODING	VARCHAR2	(30)	Yes	File encoding of the converted R12 file (which is the same as the 11.5.10 file encoding)
CONVERTED_FILE	CLOB	(4000)	Yes	The content of the converted R12 file
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Columns
CREATION_DATE	DATE		Yes	Standard WHO Columns
CREATED_BY	NUMBER		Yes	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Columns
REQUEST_ID	NUMBER		Yes	Standard Concurrent Request Column: Identifies the concurrent request instance that spawned the concurrent program
PROGRAM_APPLICATION_ID	NUMBER			Standard Concurrent Request Column: Identifies the Oracle Application that spawned the concurrent program
PROGRAM_ID	NUMBER			Standard Concurrent Request Column: Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER			Standard Concurrent Request Column: Identifies the Oracle Applications Concurrent Program Login ID

Query Text

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


SELECT FILE_ID
,      FILE_NAME
,      SUPPLIER_NAME
,      SUPPLIER_SITE
,      OPERATING_UNIT
,      CURRENCY_CODE
,      CONTRACT_NUMBER
,      FILE_ENCODING
,      CONVERTED_FILE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
FROM ICX.ICX_CAT_CONVERTER_DETAILS;

Dependencies

[top of page]

ICX.ICX_CAT_CONVERTER_DETAILS does not reference any database object

ICX.ICX_CAT_CONVERTER_DETAILS is referenced by following:

APPS: ICX_CAT_CONVERTER_DETAILS