[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:
|
|
|