VIEW: CZ.CZ_IMP_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, ORGANIZATION_ID ORGANIZATION_ID, ITEM_ID ITEM_ID, EXPLOSION_TYPE EXPLOSION_TYPE, NAME NAME, ORIG_SYS_REF ORIG_SYS_REF, RESOURCE_FLAG RESOURCE_FLAG, TOP_ITEM_ID TOP_ITEM_ID, 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, RUN_ID RUN_ID, REC_STATUS REC_STATUS, DISPOSITION DISPOSITION, DELETED_FLAG DELETED_FLAG, EFF_FROM EFF_FROM, EFF_TO EFF_TO, EFF_MASK EFF_MASK, USER_STR01 USER_STR01, USER_STR02 USER_STR02, USER_STR03 USER_STR03, USER_STR04 USER_STR04, USER_NUM01 USER_NUM01, USER_NUM02 USER_NUM02, USER_NUM03 USER_NUM03, USER_NUM04 USER_NUM04, CHECKOUT_USER CHECKOUT_USER, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, FSK_INTLTEXT_1_1 FSK_INTLTEXT_1_1, FSK_INTLTEXT_1_EXT FSK_INTLTEXT_1_EXT, FSK_ITEMMASTER_2_1 FSK_ITEMMASTER_2_1, FSK_ITEMMASTER_2_EXT FSK_ITEMMASTER_2_EXT, FSK_PSNODE_3_1 FSK_PSNODE_3_1, FSK_PSNODE_3_EXT FSK_PSNODE_3_EXT, FSK_PSNODE_4_1 FSK_PSNODE_4_1, FSK_PSNODE_4_EXT FSK_PSNODE_4_EXT, FSK_DEVLPROJECT_5_1 FSK_DEVLPROJECT_5_1, FSK_DEVLPROJECT_5_EXT FSK_DEVLPROJECT_5_EXT, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, COMPONENT_CODE COMPONENT_CODE, PLAN_LEVEL PLAN_LEVEL, BOM_ITEM_TYPE BOM_ITEM_TYPE, SO_ITEM_TYPE_CODE SO_ITEM_TYPE_CODE, MINIMUM_SELECTED MINIMUM_SELECTED, MAXIMUM_SELECTED MAXIMUM_SELECTED, BOM_REQUIRED BOM_REQUIRED, MUTUALLY_EXCLUSIVE_OPTIONS MUTUALLY_EXCLUSIVE_OPTIONS, OPTIONAL OPTIONAL, FSK_EXPLNODE_1_1 FSK_EXPLNODE_1_1, FSK_PSNODE_6_1 FSK_PSNODE_6_1, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_UNTIL EFFECTIVE_UNTIL, EFFECTIVE_USAGE_MASK EFFECTIVE_USAGE_MASK, EFFECTIVITY_SET_ID EFFECTIVITY_SET_ID, FSK_EFFSET_7_1 FSK_EFFSET_7_1, DECIMAL_QTY_FLAG DECIMAL_QTY_FLAG, QUOTEABLE_FLAG QUOTEABLE_FLAG, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, COMPONENT_SEQUENCE_PATH COMPONENT_SEQUENCE_PATH, BOM_SORT_ORDER BOM_SORT_ORDER, IB_TRACKABLE IB_TRACKABLE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INITIAL_NUM_VALUE INITIAL_NUM_VALUE, SRC_APPLICATION_ID SRC_APPLICATION_ID, FSK_ITEMMASTER_2_2 FSK_ITEMMASTER_2_2, INSTANTIABLE_FLAG INSTANTIABLE_FLAG, DISPLAY_IN_SUMMARY_FLAG DISPLAY_IN_SUMMARY_FLAG, IB_LINK_ITEM_FLAG IB_LINK_ITEM_FLAG, 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, 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_IMP_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
, ORGANIZATION_ID ORGANIZATION_ID
, ITEM_ID ITEM_ID
, EXPLOSION_TYPE EXPLOSION_TYPE
, NAME NAME
, ORIG_SYS_REF ORIG_SYS_REF
, RESOURCE_FLAG RESOURCE_FLAG
, TOP_ITEM_ID TOP_ITEM_ID
, 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
, RUN_ID RUN_ID
, REC_STATUS REC_STATUS
, DISPOSITION DISPOSITION
, DELETED_FLAG DELETED_FLAG
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
, EFF_MASK EFF_MASK
, USER_STR01 USER_STR01
, USER_STR02 USER_STR02
, USER_STR03 USER_STR03
, USER_STR04 USER_STR04
, USER_NUM01 USER_NUM01
, USER_NUM02 USER_NUM02
, USER_NUM03 USER_NUM03
, USER_NUM04 USER_NUM04
, CHECKOUT_USER CHECKOUT_USER
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, FSK_INTLTEXT_1_1 FSK_INTLTEXT_1_1
, FSK_INTLTEXT_1_EXT FSK_INTLTEXT_1_EXT
, FSK_ITEMMASTER_2_1 FSK_ITEMMASTER_2_1
, FSK_ITEMMASTER_2_EXT FSK_ITEMMASTER_2_EXT
, FSK_PSNODE_3_1 FSK_PSNODE_3_1
, FSK_PSNODE_3_EXT FSK_PSNODE_3_EXT
, FSK_PSNODE_4_1 FSK_PSNODE_4_1
, FSK_PSNODE_4_EXT FSK_PSNODE_4_EXT
, FSK_DEVLPROJECT_5_1 FSK_DEVLPROJECT_5_1
, FSK_DEVLPROJECT_5_EXT FSK_DEVLPROJECT_5_EXT
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, COMPONENT_CODE COMPONENT_CODE
, PLAN_LEVEL PLAN_LEVEL
, BOM_ITEM_TYPE BOM_ITEM_TYPE
, SO_ITEM_TYPE_CODE SO_ITEM_TYPE_CODE
, MINIMUM_SELECTED MINIMUM_SELECTED
, MAXIMUM_SELECTED MAXIMUM_SELECTED
, BOM_REQUIRED BOM_REQUIRED
, MUTUALLY_EXCLUSIVE_OPTIONS MUTUALLY_EXCLUSIVE_OPTIONS
, OPTIONAL OPTIONAL
, FSK_EXPLNODE_1_1 FSK_EXPLNODE_1_1
, FSK_PSNODE_6_1 FSK_PSNODE_6_1
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_UNTIL EFFECTIVE_UNTIL
, EFFECTIVE_USAGE_MASK EFFECTIVE_USAGE_MASK
, EFFECTIVITY_SET_ID EFFECTIVITY_SET_ID
, FSK_EFFSET_7_1 FSK_EFFSET_7_1
, DECIMAL_QTY_FLAG DECIMAL_QTY_FLAG
, QUOTEABLE_FLAG QUOTEABLE_FLAG
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, COMPONENT_SEQUENCE_PATH COMPONENT_SEQUENCE_PATH
, BOM_SORT_ORDER BOM_SORT_ORDER
, IB_TRACKABLE IB_TRACKABLE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INITIAL_NUM_VALUE INITIAL_NUM_VALUE
, SRC_APPLICATION_ID SRC_APPLICATION_ID
, FSK_ITEMMASTER_2_2 FSK_ITEMMASTER_2_2
, INSTANTIABLE_FLAG INSTANTIABLE_FLAG
, DISPLAY_IN_SUMMARY_FLAG DISPLAY_IN_SUMMARY_FLAG
, IB_LINK_ITEM_FLAG IB_LINK_ITEM_FLAG
, 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
, 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_IMP_PS_NODES"