[Home] [Help]
[Dependency Information]
[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#;
CZ
CZ_PS_NODES
APPS
CZ_PS_NODES
CZ_PS_NODES_T1
CZ_PS_NODES_T2
CZ_PS_NODES_T3
CZ_PS_NODES_T4
CZ_PS_NODES_T5
CZ_PS_NODES_T6
CZ_PS_NODES_TP1
|
|
|
|