VIEW: CZ.CZ_PS_NODES#

Source

View Text - Preformatted

select PS_NODE_ID PS_NODE_ID, DEVL_PROJECT_ID DEVL_PROJECT_ID, FROM_POPULATOR_ID FROM_POPULATOR_ID, PROPERTY_BACKPTR PROPERTY_BACKPTR, ITEM_TYPE_BACKPTR ITEM_TYPE_BACKPTR, INTL_TEXT_ID INTL_TEXT_ID, SUB_CONS_ID SUB_CONS_ID, ITEM_ID ITEM_ID, NAME NAME, ORIG_SYS_REF ORIG_SYS_REF, RESOURCE_FLAG RESOURCE_FLAG, INITIAL_VALUE INITIAL_VALUE, PARENT_ID PARENT_ID, MINIMUM MINIMUM, MAXIMUM MAXIMUM, PS_NODE_TYPE PS_NODE_TYPE, FEATURE_TYPE FEATURE_TYPE, PRODUCT_FLAG PRODUCT_FLAG, REFERENCE_ID REFERENCE_ID, MULTI_CONFIG_FLAG MULTI_CONFIG_FLAG, ORDER_SEQ_FLAG ORDER_SEQ_FLAG, SYSTEM_NODE_FLAG SYSTEM_NODE_FLAG, TREE_SEQ TREE_SEQ, COUNTED_OPTIONS_FLAG COUNTED_OPTIONS_FLAG, UI_OMIT UI_OMIT, UI_SECTION UI_SECTION, BOM_TREATMENT BOM_TREATMENT, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, BOM_REQUIRED_FLAG BOM_REQUIRED_FLAG, SO_ITEM_TYPE_CODE SO_ITEM_TYPE_CODE, MINIMUM_SELECTED MINIMUM_SELECTED, MAXIMUM_SELECTED MAXIMUM_SELECTED, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETED_FLAG DELETED_FLAG, EFF_FROM EFF_FROM, EFF_TO EFF_TO, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, EFF_MASK EFF_MASK, CHECKOUT_USER CHECKOUT_USER, USER_NUM01 USER_NUM01, USER_NUM02 USER_NUM02, USER_NUM03 USER_NUM03, USER_NUM04 USER_NUM04, USER_STR01 USER_STR01, USER_STR02 USER_STR02, USER_STR03 USER_STR03, USER_STR04 USER_STR04, VIRTUAL_FLAG VIRTUAL_FLAG, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EFFECTIVE_USAGE_MASK EFFECTIVE_USAGE_MASK, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_UNTIL EFFECTIVE_UNTIL, DECIMAL_QTY_FLAG DECIMAL_QTY_FLAG, PERSISTENT_NODE_ID PERSISTENT_NODE_ID, COMPONENT_SEQUENCE_PATH COMPONENT_SEQUENCE_PATH, VIOLATION_TEXT_ID VIOLATION_TEXT_ID, EFFECTIVITY_SET_ID EFFECTIVITY_SET_ID, QUOTEABLE_FLAG QUOTEABLE_FLAG, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, BOM_SORT_ORDER BOM_SORT_ORDER, IB_TRACKABLE IB_TRACKABLE, COMPONENT_ID COMPONENT_ID, INITIAL_NUM_VALUE INITIAL_NUM_VALUE, INSTANTIABLE_FLAG INSTANTIABLE_FLAG, ACCUMULATOR_FLAG ACCUMULATOR_FLAG, NOTES_TEXT_ID NOTES_TEXT_ID, DISPLAYNAME_CAPT_RULE_ID DISPLAYNAME_CAPT_RULE_ID, SRC_APPLICATION_ID SRC_APPLICATION_ID, MAX_TEXT_LENGTH MAX_TEXT_LENGTH, DISPLAYNAME_TEXT_ID DISPLAYNAME_TEXT_ID, MAX_LENGTH MAX_LENGTH, DISPLAY_IN_SUMMARY_FLAG DISPLAY_IN_SUMMARY_FLAG, TRANSIENT_FLAG TRANSIENT_FLAG, IB_LINK_ITEM_FLAG IB_LINK_ITEM_FLAG, LAST_STRUCT_UPDATE LAST_STRUCT_UPDATE, SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG, INVENTORY_TRANSACTABLE_FLAG INVENTORY_TRANSACTABLE_FLAG, ASSEMBLE_TO_ORDER_FLAG ASSEMBLE_TO_ORDER_FLAG, SERIALIZABLE_ITEM_FLAG SERIALIZABLE_ITEM_FLAG, UI_TIMESTAMP_ADD UI_TIMESTAMP_ADD, UI_TIMESTAMP_REMOVE UI_TIMESTAMP_REMOVE, UI_TIMESTAMP_MOVE UI_TIMESTAMP_MOVE, UI_TIMESTAMP_CHANGETYPE UI_TIMESTAMP_CHANGETYPE, UI_TIMESTAMP_REORDER UI_TIMESTAMP_REORDER, MAX_QTY_PER_OPTION MAX_QTY_PER_OPTION, DOMAIN_ORDER DOMAIN_ORDER, USER_INPUT_REQUIRED_FLAG USER_INPUT_REQUIRED_FLAG, REVERSE_CONNECTOR_ID REVERSE_CONNECTOR_ID from "CZ"."CZ_PS_NODES"

View Text - HTML Formatted

SELECT PS_NODE_ID PS_NODE_ID
, DEVL_PROJECT_ID DEVL_PROJECT_ID
, FROM_POPULATOR_ID FROM_POPULATOR_ID
, PROPERTY_BACKPTR PROPERTY_BACKPTR
, ITEM_TYPE_BACKPTR ITEM_TYPE_BACKPTR
, INTL_TEXT_ID INTL_TEXT_ID
, SUB_CONS_ID SUB_CONS_ID
, ITEM_ID ITEM_ID
, NAME NAME
, ORIG_SYS_REF ORIG_SYS_REF
, RESOURCE_FLAG RESOURCE_FLAG
, INITIAL_VALUE INITIAL_VALUE
, PARENT_ID PARENT_ID
, MINIMUM MINIMUM
, MAXIMUM MAXIMUM
, PS_NODE_TYPE PS_NODE_TYPE
, FEATURE_TYPE FEATURE_TYPE
, PRODUCT_FLAG PRODUCT_FLAG
, REFERENCE_ID REFERENCE_ID
, MULTI_CONFIG_FLAG MULTI_CONFIG_FLAG
, ORDER_SEQ_FLAG ORDER_SEQ_FLAG
, SYSTEM_NODE_FLAG SYSTEM_NODE_FLAG
, TREE_SEQ TREE_SEQ
, COUNTED_OPTIONS_FLAG COUNTED_OPTIONS_FLAG
, UI_OMIT UI_OMIT
, UI_SECTION UI_SECTION
, BOM_TREATMENT BOM_TREATMENT
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, BOM_REQUIRED_FLAG BOM_REQUIRED_FLAG
, SO_ITEM_TYPE_CODE SO_ITEM_TYPE_CODE
, MINIMUM_SELECTED MINIMUM_SELECTED
, MAXIMUM_SELECTED MAXIMUM_SELECTED
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETED_FLAG DELETED_FLAG
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, EFF_MASK EFF_MASK
, CHECKOUT_USER CHECKOUT_USER
, USER_NUM01 USER_NUM01
, USER_NUM02 USER_NUM02
, USER_NUM03 USER_NUM03
, USER_NUM04 USER_NUM04
, USER_STR01 USER_STR01
, USER_STR02 USER_STR02
, USER_STR03 USER_STR03
, USER_STR04 USER_STR04
, VIRTUAL_FLAG VIRTUAL_FLAG
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EFFECTIVE_USAGE_MASK EFFECTIVE_USAGE_MASK
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_UNTIL EFFECTIVE_UNTIL
, DECIMAL_QTY_FLAG DECIMAL_QTY_FLAG
, PERSISTENT_NODE_ID PERSISTENT_NODE_ID
, COMPONENT_SEQUENCE_PATH COMPONENT_SEQUENCE_PATH
, VIOLATION_TEXT_ID VIOLATION_TEXT_ID
, EFFECTIVITY_SET_ID EFFECTIVITY_SET_ID
, QUOTEABLE_FLAG QUOTEABLE_FLAG
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, BOM_SORT_ORDER BOM_SORT_ORDER
, IB_TRACKABLE IB_TRACKABLE
, COMPONENT_ID COMPONENT_ID
, INITIAL_NUM_VALUE INITIAL_NUM_VALUE
, INSTANTIABLE_FLAG INSTANTIABLE_FLAG
, ACCUMULATOR_FLAG ACCUMULATOR_FLAG
, NOTES_TEXT_ID NOTES_TEXT_ID
, DISPLAYNAME_CAPT_RULE_ID DISPLAYNAME_CAPT_RULE_ID
, SRC_APPLICATION_ID SRC_APPLICATION_ID
, MAX_TEXT_LENGTH MAX_TEXT_LENGTH
, DISPLAYNAME_TEXT_ID DISPLAYNAME_TEXT_ID
, MAX_LENGTH MAX_LENGTH
, DISPLAY_IN_SUMMARY_FLAG DISPLAY_IN_SUMMARY_FLAG
, TRANSIENT_FLAG TRANSIENT_FLAG
, IB_LINK_ITEM_FLAG IB_LINK_ITEM_FLAG
, LAST_STRUCT_UPDATE LAST_STRUCT_UPDATE
, SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG
, INVENTORY_TRANSACTABLE_FLAG INVENTORY_TRANSACTABLE_FLAG
, ASSEMBLE_TO_ORDER_FLAG ASSEMBLE_TO_ORDER_FLAG
, SERIALIZABLE_ITEM_FLAG SERIALIZABLE_ITEM_FLAG
, UI_TIMESTAMP_ADD UI_TIMESTAMP_ADD
, UI_TIMESTAMP_REMOVE UI_TIMESTAMP_REMOVE
, UI_TIMESTAMP_MOVE UI_TIMESTAMP_MOVE
, UI_TIMESTAMP_CHANGETYPE UI_TIMESTAMP_CHANGETYPE
, UI_TIMESTAMP_REORDER UI_TIMESTAMP_REORDER
, MAX_QTY_PER_OPTION MAX_QTY_PER_OPTION
, DOMAIN_ORDER DOMAIN_ORDER
, USER_INPUT_REQUIRED_FLAG USER_INPUT_REQUIRED_FLAG
, REVERSE_CONNECTOR_ID REVERSE_CONNECTOR_ID
FROM "CZ"."CZ_PS_NODES"