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_LOAD_SPECS

Object Details

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

This table specifies the conditions and attachment points for loading LCE files. Attachment via Component PS Node ID and via the more precise Model-Reference Explosion ID are both included.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_LCE_LOAD_SPECS_PK

LCE_HEADER_ID
ATTACHMENT_EXPL_ID
REQUIRED_EXPL_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_LCE_LOAD_SPECS_PK	NORMAL	UNIQUE	APPS_TS_SEED	LCE_HEADER_ID ATTACHMENT_EXPL_ID REQUIRED_EXPL_ID
CZ_LCE_LOAD_SPECS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	ATTACHMENT_EXPL_ID DELETED_FLAG LCE_HEADER_ID
CZ_LCE_LOAD_SPECS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	ATTACHMENT_COMP_ID DELETED_FLAG NET_TYPE LCE_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ATTACHMENT_EXPL_ID	NUMBER		Yes	Model Ref Expl ID of the component into whose net the specified LCE file is to be loaded. FK TO CZ MODEL REF EXPLS
LCE_HEADER_ID	NUMBER		Yes	Identifies the LCE file to be loaded
REQUIRED_EXPL_ID	NUMBER		Yes	Specifies a Connector or (0,1) sub-Component that must be connected or instantiated for this LCE Header to be loaded under the Attachment Expl.
MODEL_ID	NUMBER		Yes	Model ID in which these explosions and LCE file reside. Denormalization from CZ MODEL REF EXPLS
ATTACHMENT_COMP_ID	NUMBER		Yes	PS_NODE_ID of component to which ATTACHMENT_EXPL_ID refers. Denormalization from CZ MODEL REF EXPLS
NET_TYPE	NUMBER		Yes	Identifies the type of LCE file to which this record refers. Denormalized from CZ LCE HEADERS. 1 - Structure; 2 - mandatory Rules; 3 - conditional rules (obsolete); 4 - connector rules
DELETED_FLAG	VARCHAR2	(1)	Yes	Standard flag for determining whether this record is active ('0') or deleted ('1'). All other values reserved for Oracle use.
CREATION_DATE	DATE		Yes	Standard footprint field. Date this record was created.
CREATED_BY	NUMBER		Yes	Standard footprint field. Identifies Applications user that created this record
LAST_UPDATE_DATE	DATE		Yes	Standard footprint field. Date this record was last updated.
LAST_UPDATED_BY	NUMBER		Yes	Standard footprint field. Identifies Applications user that last updated this record.
LAST_UPDATE_LOGIN	NUMBER			Standard footprint field. Specifies login under which this record was last updated.
ALIAS_NAME	VARCHAR2	(128)		Used for loading Connectors (NET_TYPE = 4) only. Specifies a unique 'alias' used to refer to the Connector target when connected.

Query Text

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


SELECT ATTACHMENT_EXPL_ID
,      LCE_HEADER_ID
,      REQUIRED_EXPL_ID
,      MODEL_ID
,      ATTACHMENT_COMP_ID
,      NET_TYPE
,      DELETED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ALIAS_NAME
FROM CZ.CZ_LCE_LOAD_SPECS;

Dependencies

[top of page]

CZ.CZ_LCE_LOAD_SPECS does not reference any database object

CZ.CZ_LCE_LOAD_SPECS is referenced by following:

APPS: CZ_LCE_LOAD_SPECS; CZ_LCE_LOAD_SPECS_T1