[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CZ_IMP_MODEL_REF_EXPLS |
|---|---|
| Object Type: | TABLE |
| Owner: | CZ |
| FND Design Data: |  CZ.CZ_IMP_MODEL_REF_EXPLS
|
| Subobject Name: | |
| Status: | VALID |
The CZ_MODEL_REF_EXPLS table enumerates the logical tree structure that is specified by the system of nodes and referenced models under a single model. The unique identity of an explosion ID and the model PSNODE ID provides the exact structural address of any node in a model regardless of how many models are included by reference, and regardless of whether the same child model repeats in the system of referenced models.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MODEL_REF_EXPL_ID | NUMBER | (9) | Yes | Associates this record with a model-reference explosion node in the current model |
| 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 | |
| RUN_ID | NUMBER | (9) | Associates this record with a specific batch run (import, publish, purge, etc.) | |
| DISPOSITION | VARCHAR2 | (1) | Indicates whether the record was inserted, updated, unchanged, or rejected | |
| REC_STATUS | VARCHAR2 | (4) | Coded description of the import status of this record; 'OK' indicates success | |
| FSK_EXPLNODE_1_1 | VARCHAR2 | (255) | Contains a foreign surrogate-key value for CZ_MODEL_REF_EXPLS on parent_expl_node_id | |
| FSK_EXPLNODE_2_1 | VARCHAR2 | (255) | Contains a foreign surrogate-key value for CZ_MODEL_REF_EXPLS on child_model_expl_id | |
| FSK_PSNODE_1_1 | VARCHAR2 | (255) | contains a foreign surrogate-key value matching CZ_PS_NODES on component_id | |
| FSK_MODEL_1_1 | VARCHAR2 | (255) | Contains a foreign surrogate-key value matching CZ_DEVL_PROJECTS on model_id | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who field |
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
, RUN_ID
, DISPOSITION
, REC_STATUS
, FSK_EXPLNODE_1_1
, FSK_EXPLNODE_2_1
, FSK_PSNODE_1_1
, FSK_MODEL_1_1
, LAST_UPDATE_LOGIN
FROM CZ.CZ_IMP_MODEL_REF_EXPLS;
CZ.CZ_IMP_MODEL_REF_EXPLS does not reference any database object
CZ.CZ_IMP_MODEL_REF_EXPLS is referenced by following:
APPS
CZ_IMP_MODEL_REF_EXPLS
|
|
|
|