[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_COMPATCELL_NODE_V is not referenced by any database object
|
|
|