[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CZ_COMPATCELL_NODE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CZ.CZ_COMPATCELL_NODE_V
|
| Subobject Name: | |
| Status: | VALID |
CZ_COMPATCELL_NODE_V lists all of the entries ("cells") in a Configurator Design Chart with the data from that cell's associated Secondary Option/Secondary Standard Item
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RULE_ID | NUMBER | (9) | Yes | |
| PRIMARY_OPT_ID | NUMBER | (15) | Yes | |
| SECONDARY_OPT_ID | NUMBER | (15) | Yes | |
| MARK_CHAR | VARCHAR2 | (1) | ||
| DELETED_FLAG | VARCHAR2 | (1) | Yes | |
| SECONDARY_FEAT_EXPL_ID | NUMBER | (9) | Yes | |
| SECONDARY_FEATURE_ID | NUMBER | (15) | Yes | |
| PS_NODE_ID | NUMBER | (15) | Yes | |
| DEVL_PROJECT_ID | NUMBER | (15) | ||
| FROM_POPULATOR_ID | NUMBER | (9) | ||
| PROPERTY_BACKPTR | NUMBER | (9) | ||
| ITEM_TYPE_BACKPTR | NUMBER | (9) | ||
| INTL_TEXT_ID | NUMBER | (15) | ||
| SUB_CONS_ID | NUMBER | (9) | ||
| ITEM_ID | NUMBER | (9) | ||
| NAME | VARCHAR2 | (1000) | ||
| ORIG_SYS_REF | VARCHAR2 | (1200) | ||
| RESOURCE_FLAG | VARCHAR2 | (1) | ||
| INITIAL_VALUE | VARCHAR2 | (4000) | ||
| PARENT_ID | NUMBER | (15) | ||
| MINIMUM | NUMBER | |||
| MAXIMUM | NUMBER | |||
| PS_NODE_TYPE | NUMBER | (9) | Yes | |
| FEATURE_TYPE | NUMBER | (9) | ||
| PRODUCT_FLAG | VARCHAR2 | (1) | ||
| REFERENCE_ID | NUMBER | (15) | ||
| MULTI_CONFIG_FLAG | VARCHAR2 | (1) | ||
| ORDER_SEQ_FLAG | VARCHAR2 | (1) | ||
| SYSTEM_NODE_FLAG | VARCHAR2 | (1) | ||
| TREE_SEQ | NUMBER | (9) | Yes | |
| 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) | ||
| 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) | ||
| VIRTUAL_FLAG | VARCHAR2 | (1) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| EFFECTIVE_USAGE_MASK | VARCHAR2 | (16) | Yes | |
| EFFECTIVE_FROM | DATE | |||
| EFFECTIVE_UNTIL | DATE | |||
| DECIMAL_QTY_FLAG | VARCHAR2 | (1) | Yes | |
| PERSISTENT_NODE_ID | NUMBER | (15) | Yes | |
| 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) | ||
| COMPONENT_ID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ID
, PRIMARY_OPT_ID
, SECONDARY_OPT_ID
, MARK_CHAR
, DELETED_FLAG
, SECONDARY_FEAT_EXPL_ID
, SECONDARY_FEATURE_ID
, PS_NODE_ID
, DEVL_PROJECT_ID
, FROM_POPULATOR_ID
, PROPERTY_BACKPTR
, ITEM_TYPE_BACKPTR
, INTL_TEXT_ID
, SUB_CONS_ID
, ITEM_ID
, NAME
, ORIG_SYS_REF
, RESOURCE_FLAG
, INITIAL_VALUE
, PARENT_ID
, MINIMUM
, MAXIMUM
, PS_NODE_TYPE
, FEATURE_TYPE
, PRODUCT_FLAG
, REFERENCE_ID
, MULTI_CONFIG_FLAG
, ORDER_SEQ_FLAG
, SYSTEM_NODE_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
, USER_NUM01
, USER_NUM02
, USER_NUM03
, USER_NUM04
, USER_STR01
, USER_STR02
, USER_STR03
, USER_STR04
, VIRTUAL_FLAG
, LAST_UPDATE_LOGIN
, 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
, COMPONENT_ID
FROM APPS.CZ_COMPATCELL_NODE_V;
APPS
CZ_DES_CHART_CELLS
CZ_PS_NODES
APPS.CZ_COMPATCELL_NODE_V is not referenced by any database object
|
|
|
|