[Home] [Help] [Dependency Information]
Object Name: | CZ_PS_NODES# |
---|---|
Object Type: | VIEW |
Owner: | CZ |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
DELETED_FLAG | VARCHAR2 | (1) | Yes | |
EFF_FROM | DATE | |||
EFF_TO | DATE | |||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
SECURITY_MASK | VARCHAR2 | (40) | ||
EFF_MASK | VARCHAR2 | (40) | ||
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) | ||
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 | ||
INITIAL_NUM_VALUE | NUMBER | |||
INSTANTIABLE_FLAG | VARCHAR2 | (1) | ||
ACCUMULATOR_FLAG | VARCHAR2 | (1) | ||
NOTES_TEXT_ID | NUMBER | |||
DISPLAYNAME_CAPT_RULE_ID | NUMBER | |||
SRC_APPLICATION_ID | NUMBER | |||
MAX_TEXT_LENGTH | NUMBER | |||
DISPLAYNAME_TEXT_ID | NUMBER | |||
MAX_LENGTH | NUMBER | |||
DISPLAY_IN_SUMMARY_FLAG | VARCHAR2 | (1) | ||
TRANSIENT_FLAG | VARCHAR2 | (1) | ||
IB_LINK_ITEM_FLAG | VARCHAR2 | (1) | ||
LAST_STRUCT_UPDATE | DATE | |||
SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | ||
INVENTORY_TRANSACTABLE_FLAG | VARCHAR2 | (1) | ||
ASSEMBLE_TO_ORDER_FLAG | VARCHAR2 | (1) | ||
SERIALIZABLE_ITEM_FLAG | VARCHAR2 | (1) | ||
UI_TIMESTAMP_ADD | DATE | |||
UI_TIMESTAMP_REMOVE | DATE | |||
UI_TIMESTAMP_MOVE | DATE | |||
UI_TIMESTAMP_CHANGETYPE | DATE | |||
UI_TIMESTAMP_REORDER | DATE | |||
MAX_QTY_PER_OPTION | NUMBER | |||
DOMAIN_ORDER | NUMBER | |||
USER_INPUT_REQUIRED_FLAG | VARCHAR2 | (1) | ||
REVERSE_CONNECTOR_ID | NUMBER | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, CREATION_DATE
, LAST_UPDATE_DATE
, DELETED_FLAG
, EFF_FROM
, EFF_TO
, CREATED_BY
, LAST_UPDATED_BY
, SECURITY_MASK
, EFF_MASK
, CHECKOUT_USER
, 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
, INITIAL_NUM_VALUE
, INSTANTIABLE_FLAG
, ACCUMULATOR_FLAG
, NOTES_TEXT_ID
, DISPLAYNAME_CAPT_RULE_ID
, SRC_APPLICATION_ID
, MAX_TEXT_LENGTH
, DISPLAYNAME_TEXT_ID
, MAX_LENGTH
, DISPLAY_IN_SUMMARY_FLAG
, TRANSIENT_FLAG
, IB_LINK_ITEM_FLAG
, LAST_STRUCT_UPDATE
, SHIPPABLE_ITEM_FLAG
, INVENTORY_TRANSACTABLE_FLAG
, ASSEMBLE_TO_ORDER_FLAG
, SERIALIZABLE_ITEM_FLAG
, UI_TIMESTAMP_ADD
, UI_TIMESTAMP_REMOVE
, UI_TIMESTAMP_MOVE
, UI_TIMESTAMP_CHANGETYPE
, UI_TIMESTAMP_REORDER
, MAX_QTY_PER_OPTION
, DOMAIN_ORDER
, USER_INPUT_REQUIRED_FLAG
, REVERSE_CONNECTOR_ID
FROM CZ.CZ_PS_NODES#;
|
|
|