View: CZ_CONFIG_ITEMS_V

Product:	CZ - Configurator
Description:	Client (Installed-Base) view of CZ_CONFIG_ITEMS
Implementation/DBA Data:	APPS.CZ_CONFIG_ITEMS_V

View Text

SELECT A.CONFIG_HDR_ID
, A.CONFIG_REV_NBR
, A.CONFIG_ITEM_ID
, A.PS_NODE_ID
, A.VALUE_TYPE_CODE
, A.SEQUENCE_NBR
, NVL(A.ITEM_VAL
, TO_CHAR(A.ITEM_NUM_VAL)) AS ITEM_VAL
, A.INSTANCE_NBR
, A.PARENT_CONFIG_ITEM_ID
, A.NODE_IDENTIFIER
, A.INVENTORY_ITEM_ID
, A.ORGANIZATION_ID
, A.COMPONENT_SEQUENCE_ID
, A.UOM_CODE
, A.USER_STR01
, A.USER_STR02
, A.USER_STR03
, A.USER_STR04
, A.USER_NUM01
, A.USER_NUM02
, A.USER_NUM03
, A.USER_NUM04
, A.BOM_ITEM_TYPE
, A.QUOTEABLE_FLAG
, A.BOM_SORT_ORDER
, A.TARGET_CONFIG_ITEM_ID
, A.INSTANCE_CONFIG_ITEM_ID
, A.NAME
, A.ATO_CONFIG_ITEM_ID
, A.INSTANCE_HDR_ID
, A.INSTANCE_REV_NBR
, A.TARGET_HDR_ID
, A.TARGET_REV_NBR
, A.CONFIG_DELTA
, A.LOCATION_ID
, A.LOCATION_TYPE_CODE
, A.COMPONENT_INSTANCE_TYPE
, A.IB_TRACKABLE
, A.EXT_ACTIVATED_FLAG
, A.LINE_TYPE
, B.MODEL_INSTANTIATION_TYPE
, A. DISCONTINUED_FLAG
, A.ITEM_NUM_VAL
, A.ORIG_SYS_REF
, A.ITEM_SRC_APPL_ID
, A.PS_NODE_NAME
, A.TANGIBLE_ITEM_FLAG
, A.RETURNED_FLAG
FROM CZ_CONFIG_ITEMS A
, CZ_CONFIG_HDRS B
WHERE A.DELETED_FLAG = '0'
AND A.CONFIG_HDR_ID = B.CONFIG_HDR_ID
AND A.CONFIG_REV_NBR = B.CONFIG_REV_NBR

Columns