[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CZ_EXPLNODES_WITHIMAGES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CZ.CZ_EXPLNODES_WITHIMAGES_V
|
| Subobject Name: | |
| Status: | VALID |
| 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) | ||
| PSN_COMPONENT_ID | NUMBER | |||
| XPL_COMPONENT_ID | NUMBER | (15) | ||
| PSN_VIRTUAL_FLAG | VARCHAR2 | (1) | ||
| XPL_VIRTUAL_FLAG | VARCHAR2 | (1) | ||
| PS_NODE_TYPE | NUMBER | (9) | ||
| IMAGE_USAGE_CODE | NUMBER | |||
| REFERENCED_USAGE_FLAG | VARCHAR2 | (1) | ||
| PSNODETYPE_ID | NUMBER | |||
| PSNODETYPE_NAME | VARCHAR2 | (30) | ||
| IMAGE_FILE | VARCHAR2 | (4000) | ||
| ALT_TEXT | VARCHAR2 | (2000) | ||
| DETAILED_TYPE_ID | NUMBER | |||
| UI_DEF_ID | NUMBER | |||
| FULL_IMAGE_PATH | VARCHAR2 | (4000) | ||
| PSN_CREATION_DATE | DATE | |||
| PSN_CREATED_BY | NUMBER | (15) | ||
| PSN_LAST_UPDATE_DATE | DATE | |||
| PSN_LAST_UPDATED_BY | NUMBER | (15) | ||
| INITIAL_NUM_VALUE | NUMBER | |||
| TEXT_STR | VARCHAR2 | (2000) | ||
| LANGUAGE | VARCHAR2 | (4) | ||
| ORGANIZATION_ID | NUMBER | |||
| TOP_ITEM_ID | NUMBER | |||
| INVENTORY_ITEM_ID | NUMBER | |||
| ATTACH_NODETYPE_ALT_TEXT | VARCHAR2 | (2000) | ||
| USER_PREF_NODE_PATH | VARCHAR2 | (4000) | ||
| USER_PREF_NODE_LABEL | VARCHAR2 | (4000) | ||
| NAME_ONLY_NODE_PATH | VARCHAR2 | (4000) | ||
| DISPLAY_REORDER_CHILD_IMG | VARCHAR2 | (1) |
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
, PSN_COMPONENT_ID
, XPL_COMPONENT_ID
, PSN_VIRTUAL_FLAG
, XPL_VIRTUAL_FLAG
, PS_NODE_TYPE
, IMAGE_USAGE_CODE
, REFERENCED_USAGE_FLAG
, PSNODETYPE_ID
, PSNODETYPE_NAME
, IMAGE_FILE
, ALT_TEXT
, DETAILED_TYPE_ID
, UI_DEF_ID
, FULL_IMAGE_PATH
, PSN_CREATION_DATE
, PSN_CREATED_BY
, PSN_LAST_UPDATE_DATE
, PSN_LAST_UPDATED_BY
, INITIAL_NUM_VALUE
, TEXT_STR
, LANGUAGE
, ORGANIZATION_ID
, TOP_ITEM_ID
, INVENTORY_ITEM_ID
, ATTACH_NODETYPE_ALT_TEXT
, USER_PREF_NODE_PATH
, USER_PREF_NODE_LABEL
, NAME_ONLY_NODE_PATH
, DISPLAY_REORDER_CHILD_IMG
FROM APPS.CZ_EXPLNODES_WITHIMAGES_V;
APPS
CZ_DEVELOPER_UTILS_PVT
- show dependent code
CZ_EXPLMODEL_NODES_V
CZ_LOCALIZED_TEXTS_VL
CZ_PSNODETYPE_IMAGES_V
CZ_PS_NODES
CZ_TYPES
- show dependent code
CZ_UTILS
- show dependent code
PUBLIC
DUAL
APPS
CZ_EXPLNODES_AVAILVALUES_CV
CZ_NODE_ALL_PROPERTIES_V
CZ_PSNODES_FOR_UIELEMS_CV
|
|
|
|