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: CZ.CZ_LCE_CLOBS

Object Details

Object Name:	CZ_LCE_CLOBS
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_LCE_CLOBS
Subobject Name:
Status:	VALID

Each row in this table contains the compiled logic for a component in an Oracle Configurator model. It corresponds to multiple rows in CZ_LCE_TEXTS, CZ_LCE_LINES, and CZ_LCE_OPERANDS. By storing the entirety of the logic in a single row in a CLOB field, the time to load this logic is greatly reduced.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_LCE_CLOBS_PK	NORMAL	UNIQUE	APPS_TS_SEED	LCE_HEADER_ID
SYS_IL0000098819C00002$$	LOB	UNIQUE	APPS_TS_SEED

Columns

Name	Datatype	Length	Mandatory	Comments
LCE_HEADER_ID	NUMBER	(9)	Yes	Identifies the LCE set/file implemented by the file in this record
LCE_FILE	CLOB	(4000)	Yes	Contains the entire LCE 'file' or set of generated logic

Query Text

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


SELECT LCE_HEADER_ID
,      LCE_FILE
FROM CZ.CZ_LCE_CLOBS;

Dependencies

[top of page]

CZ.CZ_LCE_CLOBS does not reference any database object

CZ.CZ_LCE_CLOBS is referenced by following:

APPS: CZ_LCE_CLOBS