VIEW: CZ.CZ_CONFIG_ITEMS#

Source

View Text - Preformatted

select CONFIG_HDR_ID CONFIG_HDR_ID, CONFIG_REV_NBR CONFIG_REV_NBR, CONFIG_ITEM_ID CONFIG_ITEM_ID, PS_NODE_ID PS_NODE_ID, VALUE_TYPE_CODE VALUE_TYPE_CODE, ROOT_BOM_CONFIG_ITEM_ID ROOT_BOM_CONFIG_ITEM_ID, SEQUENCE_NBR SEQUENCE_NBR, ITEM_VAL ITEM_VAL, INSTANCE_NBR INSTANCE_NBR, PARENT_CONFIG_ITEM_ID PARENT_CONFIG_ITEM_ID, NODE_IDENTIFIER NODE_IDENTIFIER, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, 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, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, UOM_CODE UOM_CODE, BOM_ITEM_TYPE BOM_ITEM_TYPE, QUOTABLE_FLAG QUOTABLE_FLAG, 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, BOM_SORT_ORDER BOM_SORT_ORDER, QUOTEABLE_FLAG QUOTEABLE_FLAG, TARGET_CONFIG_ITEM_ID TARGET_CONFIG_ITEM_ID, INSTANCE_CONFIG_ITEM_ID INSTANCE_CONFIG_ITEM_ID, NAME NAME, ATO_CONFIG_ITEM_ID ATO_CONFIG_ITEM_ID, INSTANCE_HDR_ID INSTANCE_HDR_ID, INSTANCE_REV_NBR INSTANCE_REV_NBR, COMPONENT_INSTANCE_TYPE COMPONENT_INSTANCE_TYPE, DISCONTINUED_FLAG DISCONTINUED_FLAG, TARGET_HDR_ID TARGET_HDR_ID, TARGET_REV_NBR TARGET_REV_NBR, CONFIG_DELTA CONFIG_DELTA, LINE_TYPE LINE_TYPE, LOCATION_ID LOCATION_ID, LOCATION_TYPE_CODE LOCATION_TYPE_CODE, IB_TRACKABLE IB_TRACKABLE, EXT_ACTIVATED_FLAG EXT_ACTIVATED_FLAG, ITEM_NUM_VAL ITEM_NUM_VAL, ORIG_SYS_REF ORIG_SYS_REF, ITEM_SRC_APPL_ID ITEM_SRC_APPL_ID, PS_NODE_NAME PS_NODE_NAME, TANGIBLE_ITEM_FLAG TANGIBLE_ITEM_FLAG, RETURNED_FLAG RETURNED_FLAG, VALUE_SOURCE VALUE_SOURCE, ORDERABLE_FLAG ORDERABLE_FLAG from "CZ"."CZ_CONFIG_ITEMS"

View Text - HTML Formatted

SELECT CONFIG_HDR_ID CONFIG_HDR_ID
, CONFIG_REV_NBR CONFIG_REV_NBR
, CONFIG_ITEM_ID CONFIG_ITEM_ID
, PS_NODE_ID PS_NODE_ID
, VALUE_TYPE_CODE VALUE_TYPE_CODE
, ROOT_BOM_CONFIG_ITEM_ID ROOT_BOM_CONFIG_ITEM_ID
, SEQUENCE_NBR SEQUENCE_NBR
, ITEM_VAL ITEM_VAL
, INSTANCE_NBR INSTANCE_NBR
, PARENT_CONFIG_ITEM_ID PARENT_CONFIG_ITEM_ID
, NODE_IDENTIFIER NODE_IDENTIFIER
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, 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
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, UOM_CODE UOM_CODE
, BOM_ITEM_TYPE BOM_ITEM_TYPE
, QUOTABLE_FLAG QUOTABLE_FLAG
, 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
, BOM_SORT_ORDER BOM_SORT_ORDER
, QUOTEABLE_FLAG QUOTEABLE_FLAG
, TARGET_CONFIG_ITEM_ID TARGET_CONFIG_ITEM_ID
, INSTANCE_CONFIG_ITEM_ID INSTANCE_CONFIG_ITEM_ID
, NAME NAME
, ATO_CONFIG_ITEM_ID ATO_CONFIG_ITEM_ID
, INSTANCE_HDR_ID INSTANCE_HDR_ID
, INSTANCE_REV_NBR INSTANCE_REV_NBR
, COMPONENT_INSTANCE_TYPE COMPONENT_INSTANCE_TYPE
, DISCONTINUED_FLAG DISCONTINUED_FLAG
, TARGET_HDR_ID TARGET_HDR_ID
, TARGET_REV_NBR TARGET_REV_NBR
, CONFIG_DELTA CONFIG_DELTA
, LINE_TYPE LINE_TYPE
, LOCATION_ID LOCATION_ID
, LOCATION_TYPE_CODE LOCATION_TYPE_CODE
, IB_TRACKABLE IB_TRACKABLE
, EXT_ACTIVATED_FLAG EXT_ACTIVATED_FLAG
, ITEM_NUM_VAL ITEM_NUM_VAL
, ORIG_SYS_REF ORIG_SYS_REF
, ITEM_SRC_APPL_ID ITEM_SRC_APPL_ID
, PS_NODE_NAME PS_NODE_NAME
, TANGIBLE_ITEM_FLAG TANGIBLE_ITEM_FLAG
, RETURNED_FLAG RETURNED_FLAG
, VALUE_SOURCE VALUE_SOURCE
, ORDERABLE_FLAG ORDERABLE_FLAG
FROM "CZ"."CZ_CONFIG_ITEMS"