[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CZ_EXPLMODEL_NODES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CZ.CZ_EXPLMODEL_NODES_V
|
| Subobject Name: | |
| Status: | VALID |
CZ_EXPLMODEL_NODES_V associates each Configurator Model Node with the explosion-node that exactly specifies that node's position(s) in a model, including all referenced and connected structure available to that model through its own nodes, or through the nodes of models to which it references/connects.
This view provides exactly the image of model structure presented in Configurator Developer and in pickers and reports.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SUPPRESS_FLAG | VARCHAR2 | (1) | ||
| STRUCTURAL_PARENT_ID | NUMBER | |||
| EFFECTIVE_PARENT_ID | NUMBER | |||
| PARENT_PSNODE_EXPL_ID | NUMBER | |||
| PS_NODE_ID | NUMBER | (15) | ||
| DEVL_PROJECT_ID | NUMBER | (15) | ||
| INTL_TEXT_ID | NUMBER | (15) | ||
| NAME | VARCHAR2 | (1000) | ||
| RESOURCE_FLAG | VARCHAR2 | (1) | ||
| INITIAL_VALUE | VARCHAR2 | (4000) | ||
| PARENT_ID | NUMBER | (15) | ||
| MINIMUM | NUMBER | |||
| MAXIMUM | NUMBER | |||
| FEATURE_TYPE | NUMBER | (9) | ||
| REFERENCE_ID | NUMBER | (15) | ||
| MULTI_CONFIG_FLAG | VARCHAR2 | (1) | ||
| ORDER_SEQ_FLAG | VARCHAR2 | (1) | ||
| TREE_SEQ | NUMBER | (9) | ||
| COUNTED_OPTIONS_FLAG | VARCHAR2 | (1) | ||
| UI_OMIT | VARCHAR2 | (1) | ||
| UI_SECTION | NUMBER | (9) | ||
| BOM_TREATMENT | NUMBER | (9) | ||
| COMPONENT_SEQUENCE_ID | NUMBER | (15) | ||
| BOM_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| SO_ITEM_TYPE_CODE | VARCHAR2 | (30) | ||
| MINIMUM_SELECTED | NUMBER | (9) | ||
| MAXIMUM_SELECTED | NUMBER | (9) | ||
| EFFECTIVE_USAGE_MASK | VARCHAR2 | (16) | ||
| EFFECTIVE_FROM | DATE | |||
| EFFECTIVE_UNTIL | DATE | |||
| DECIMAL_QTY_FLAG | VARCHAR2 | (1) | ||
| PERSISTENT_NODE_ID | NUMBER | (15) | ||
| COMPONENT_SEQUENCE_PATH | VARCHAR2 | (2000) | ||
| VIOLATION_TEXT_ID | NUMBER | (15) | ||
| EFFECTIVITY_SET_ID | NUMBER | (9) | ||
| QUOTEABLE_FLAG | VARCHAR2 | (1) | ||
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
| BOM_SORT_ORDER | VARCHAR2 | (4000) | ||
| IB_TRACKABLE | VARCHAR2 | (1) | ||
| ACCUMULATOR_FLAG | VARCHAR2 | (1) | ||
| NOTES_TEXT_ID | NUMBER | |||
| INSTANTIABLE_FLAG | VARCHAR2 | (1) | From underlying CZ_PS_NODES record. INSTANTIABLE_FLAG records the user's intended instantiation behavior for Component and Reference structure nodes. '1' indicates an Optional node (minimum 0 instances, maximum 1 instance); '2' indicates a Mandatory or Single instance (1, 1) node; '4' indicates a Multiply-Instantiable node, allowing a maximum of two or more instances. Also, the value '3' is used for Connectors. | |
| FROM_POPULATOR_ID | NUMBER | (9) | ||
| PROPERTY_BACKPTR | NUMBER | (9) | ||
| ITEM_TYPE_BACKPTR | NUMBER | (9) | ||
| ITEM_ID | NUMBER | (9) | ||
| ORIG_SYS_REF | VARCHAR2 | (1200) | ||
| CHECKOUT_USER | VARCHAR2 | (100) | ||
| USER_NUM01 | NUMBER | (16) | ||
| USER_NUM02 | NUMBER | (16) | ||
| USER_NUM03 | NUMBER | (16) | ||
| USER_NUM04 | NUMBER | (16) | ||
| USER_STR01 | VARCHAR2 | (255) | ||
| USER_STR02 | VARCHAR2 | (255) | ||
| USER_STR03 | VARCHAR2 | (255) | ||
| USER_STR04 | VARCHAR2 | (255) | ||
| MODEL_REF_EXPL_ID | NUMBER | |||
| PARENT_EXPL_NODE_ID | NUMBER | (9) | ||
| MODEL_ID | NUMBER | (15) | ||
| NODE_DEPTH | NUMBER | |||
| REFERRING_NODE_ID | NUMBER | |||
| CHILD_MODEL_EXPL_ID | NUMBER | |||
| EXPL_NODE_TYPE | NUMBER | |||
| HAS_TRACKABLE_CHILDREN | VARCHAR2 | (1) | ||
| VIEWREV | CHAR | (10) | ||
| COMPONENT_ID | NUMBER | |||
| PSN_COMPONENT_ID | NUMBER | |||
| XPL_COMPONENT_ID | NUMBER | (15) | ||
| PSN_VIRTUAL_FLAG | VARCHAR2 | (1) | ||
| XPL_VIRTUAL_FLAG | VARCHAR2 | (1) | ||
| PSN_PS_NODE_TYPE | NUMBER | (9) | ||
| XPL_PS_NODE_TYPE | NUMBER | (9) | ||
| PSN_DELETED_FLAG | VARCHAR2 | (1) | ||
| XPL_DELETED_FLAG | VARCHAR2 | (1) | ||
| PSN_CREATION_DATE | DATE | |||
| XPL_CREATION_DATE | DATE | |||
| PSN_LAST_UPDATE_DATE | DATE | |||
| XPL_LAST_UPDATE_DATE | DATE | |||
| PSN_CREATED_BY | NUMBER | (15) | ||
| XPL_CREATED_BY | NUMBER | (9) | ||
| PSN_LAST_UPDATED_BY | NUMBER | (15) | ||
| XPL_LAST_UPDATED_BY | NUMBER | (9) | ||
| PSN_LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| XPL_LAST_UPDATE_LOGIN | NUMBER | |||
| INITIAL_NUM_VALUE | NUMBER | |||
| TOP_ITEM_ID | NUMBER | |||
| ORGANIZATION_ID | NUMBER | |||
| INVENTORY_ITEM_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SUPPRESS_FLAG
, STRUCTURAL_PARENT_ID
, EFFECTIVE_PARENT_ID
, PARENT_PSNODE_EXPL_ID
, PS_NODE_ID
, DEVL_PROJECT_ID
, INTL_TEXT_ID
, NAME
, RESOURCE_FLAG
, INITIAL_VALUE
, PARENT_ID
, MINIMUM
, MAXIMUM
, FEATURE_TYPE
, REFERENCE_ID
, MULTI_CONFIG_FLAG
, ORDER_SEQ_FLAG
, TREE_SEQ
, COUNTED_OPTIONS_FLAG
, UI_OMIT
, UI_SECTION
, BOM_TREATMENT
, COMPONENT_SEQUENCE_ID
, BOM_REQUIRED_FLAG
, SO_ITEM_TYPE_CODE
, MINIMUM_SELECTED
, MAXIMUM_SELECTED
, EFFECTIVE_USAGE_MASK
, EFFECTIVE_FROM
, EFFECTIVE_UNTIL
, DECIMAL_QTY_FLAG
, PERSISTENT_NODE_ID
, COMPONENT_SEQUENCE_PATH
, VIOLATION_TEXT_ID
, EFFECTIVITY_SET_ID
, QUOTEABLE_FLAG
, PRIMARY_UOM_CODE
, BOM_SORT_ORDER
, IB_TRACKABLE
, ACCUMULATOR_FLAG
, NOTES_TEXT_ID
, INSTANTIABLE_FLAG
, FROM_POPULATOR_ID
, PROPERTY_BACKPTR
, ITEM_TYPE_BACKPTR
, ITEM_ID
, ORIG_SYS_REF
, CHECKOUT_USER
, USER_NUM01
, USER_NUM02
, USER_NUM03
, USER_NUM04
, USER_STR01
, USER_STR02
, USER_STR03
, USER_STR04
, MODEL_REF_EXPL_ID
, PARENT_EXPL_NODE_ID
, MODEL_ID
, NODE_DEPTH
, REFERRING_NODE_ID
, CHILD_MODEL_EXPL_ID
, EXPL_NODE_TYPE
, HAS_TRACKABLE_CHILDREN
, VIEWREV
, COMPONENT_ID
, PSN_COMPONENT_ID
, XPL_COMPONENT_ID
, PSN_VIRTUAL_FLAG
, XPL_VIRTUAL_FLAG
, PSN_PS_NODE_TYPE
, XPL_PS_NODE_TYPE
, PSN_DELETED_FLAG
, XPL_DELETED_FLAG
, PSN_CREATION_DATE
, XPL_CREATION_DATE
, PSN_LAST_UPDATE_DATE
, XPL_LAST_UPDATE_DATE
, PSN_CREATED_BY
, XPL_CREATED_BY
, PSN_LAST_UPDATED_BY
, XPL_LAST_UPDATED_BY
, PSN_LAST_UPDATE_LOGIN
, XPL_LAST_UPDATE_LOGIN
, INITIAL_NUM_VALUE
, TOP_ITEM_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
FROM APPS.CZ_EXPLMODEL_NODES_V;
APPS
CZ_DEVL_PROJECTS
CZ_MODEL_REF_EXPLS
CZ_PS_NODES
CZ_UTILS
- show dependent code
PUBLIC
DUAL
APPS
CZ_DEVELOPER_UTILS_PVT
- show dependent code
CZ_EXPLNODES_IMAGE_EFF_V
CZ_EXPLNODES_WITHIMAGES_V
CZ_FCE_COMPILE
- show dependent code
CZ_LOGIC_GEN
- show dependent code
CZ_MODEL_UTIL_PVT
- show dependent code
CZ_PSNODE_RULE_REFS_V
|
|
|
|