[Home] [Help] [Dependency Information]
Object Name: | CZ_LCE_TEXTS |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_LCE_TEXTS |
Subobject Name: | |
Status: | VALID |
This table implements aggregated storage of compiled LCE commands, storing several rows within a single field and greatly accelerating logic load from the database.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_LCE_TEXTS_PK | NORMAL | UNIQUE | APPS_TS_SEED |
LCE_HEADER_ID
SEQ_NBR |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LCE_HEADER_ID | NUMBER | (9) | Yes | Identifies the LCE set/file of which this record is part |
SEQ_NBR | NUMBER | (9) | Yes | Provides an ordering among associated records |
LCE_TEXT | VARCHAR2 | (2000) | Yes | Contains a block of LCE text that is part of the logic set/file for this LCE_HEADER_ID |
Cut, paste (and edit) the following text to query this object:
SELECT LCE_HEADER_ID
, SEQ_NBR
, LCE_TEXT
FROM CZ.CZ_LCE_TEXTS;
CZ.CZ_LCE_TEXTS does not reference any database object
CZ.CZ_LCE_TEXTS is referenced by following:
|
|
|