[Home] [Help] [Dependency Information]
Object Name: | CZ_MODEL_REF_EXPLS |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_MODEL_REF_EXPLS |
Subobject Name: | |
Status: | VALID |
This table is critical to the resolution of psnode IDs in the context of referenced models. Each record denotes a model's top-level component, or a non-virtual psnode internal to a model, through the entire parent/child tree rooted at a single "Top Model." In the context of Referencing, a product-structure node's unique identity is not just its ps_node_id, but also the model_ref_expl_id of the enclosing model/nonvirtual component.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_MODEL_REF_EXPLS_PK | NORMAL | UNIQUE | APPS_TS_SEED | MODEL_REF_EXPL_ID |
CZ_MODEL_REF_EXPLS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
MODEL_ID
COMPONENT_ID DELETED_FLAG REFERRING_NODE_ID NODE_DEPTH |
CZ_MODEL_REF_EXPLS_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED |
MODEL_ID
DELETED_FLAG MODEL_REF_EXPL_ID |
CZ_MODEL_REF_EXPLS_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED |
MODEL_ID
DELETED_FLAG PS_NODE_TYPE COMPONENT_ID MODEL_REF_EXPL_ID |
CZ_MODEL_REF_EXPLS_N4 | NORMAL | NONUNIQUE | APPS_TS_SEED |
PARENT_EXPL_NODE_ID
MODEL_REF_EXPL_ID |
CZ_MODEL_REF_EXPLS_N5 | NORMAL | NONUNIQUE | APPS_TS_SEED |
COMPONENT_ID
REFERRING_NODE_ID DELETED_FLAG |
CZ_MODEL_REF_EXPLS_N6 | NORMAL | NONUNIQUE | APPS_TS_SEED |
MODEL_ID
DELETED_FLAG REFERRING_NODE_ID |
CZ_MODEL_REF_EXPLS_N7 | NORMAL | NONUNIQUE | APPS_TS_SEED |
MODEL_ID
DELETED_FLAG PARENT_EXPL_NODE_ID |
CZ_MODEL_REF_EXPLS_N8 | NORMAL | NONUNIQUE | APPS_TS_SEED |
DELETED_FLAG
COMPONENT_ID MODEL_ID |
CZ_MODEL_REF_EXPLS_N9 | NORMAL | NONUNIQUE | APPS_TS_SEED |
DELETED_FLAG
COMPONENT_ID CHILD_MODEL_EXPL_ID MODEL_REF_EXPL_ID MODEL_ID PARENT_EXPL_NODE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MODEL_REF_EXPL_ID | NUMBER | (9) | Yes | Identity of this model-explosion record |
COMPONENT_ID | NUMBER | (15) | Yes | Identifies the component psnode to which this model-explosion record refers |
PARENT_EXPL_NODE_ID | NUMBER | (9) | Identifies the parent explosion node in the model-ref-explosions tree for this model | |
PS_NODE_TYPE | NUMBER | (9) | Yes | Associates a type with the psnode |
MODEL_ID | NUMBER | (15) | Yes | Associates this record with a configurator Model/Project |
VIRTUAL_FLAG | VARCHAR2 | (1) | Yes | Flag indicating if the associated psnode may have only one instance (virtual, '1') or different number of instances (non-virtual, '0'). |
NODE_DEPTH | NUMBER | (9) | Yes | Records the depth of this explosion node in the model-reference-component hierarchy |
DELETED_FLAG | VARCHAR2 | (1) | Yes | Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved |
REFERRING_NODE_ID | NUMBER | (15) | For explosion nodes that describe references, this field contains theps_node_id of that reference node. | |
CHILD_MODEL_EXPL_ID | NUMBER | (9) | For explosion nodes that describe references, this field contains the explosion ID at the top of the referenced model. | |
CREATED_BY | NUMBER | (9) | Yes | Standard field recording the ID of the user that created this record |
CREATION_DATE | DATE | Yes | Standard field recording the date this record was created | |
LAST_UPDATED_BY | NUMBER | (9) | Yes | Standard field recording the ID of the user that last updated this record |
LAST_UPDATE_DATE | DATE | Yes | Standard field recording the date/time this record was last updated | |
EXPL_NODE_TYPE | NUMBER | Yes | To identify the explosion node type: 1 (optional), 2 (mandatory), 3 (connector), 4 (multiply instantiable). | |
HAS_TRACKABLE_CHILDREN | VARCHAR2 | (1) | ROLLUP. Indicates whether components under this explosion are IB-trackable items. | |
LAST_UPDATE_LOGIN | NUMBER | Standard field recording the user/number this record was last login |
Cut, paste (and edit) the following text to query this object:
SELECT MODEL_REF_EXPL_ID
, COMPONENT_ID
, PARENT_EXPL_NODE_ID
, PS_NODE_TYPE
, MODEL_ID
, VIRTUAL_FLAG
, NODE_DEPTH
, DELETED_FLAG
, REFERRING_NODE_ID
, CHILD_MODEL_EXPL_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, EXPL_NODE_TYPE
, HAS_TRACKABLE_CHILDREN
, LAST_UPDATE_LOGIN
FROM CZ.CZ_MODEL_REF_EXPLS;
CZ.CZ_MODEL_REF_EXPLS does not reference any database object
CZ.CZ_MODEL_REF_EXPLS is referenced by following:
|
|
|