View: CZ_CONFIG_DETAILS_V

Product:	CZ - Configurator
Description:	Information required to use a saved configuration
Implementation/DBA Data:	APPS.CZ_CONFIG_DETAILS_V

View Text

SELECT CZ_CONFIG_ITEMS.CONFIG_HDR_ID
, CZ_CONFIG_ITEMS.CONFIG_REV_NBR
, CZ_CONFIG_ITEMS.CONFIG_ITEM_ID
, CZ_CONFIG_ITEMS.PARENT_CONFIG_ITEM_ID
, CZ_UTILS.CONV_NUM(DECODE(CZ_CONFIG_ITEMS.SEQUENCE_NBR
, 0
, NULL
, CZ_CONFIG_ITEMS.SEQUENCE_NBR)) AS SEQUENCE_NBR
, CZ_CONFIG_ITEMS.INVENTORY_ITEM_ID
, CZ_CONFIG_ITEMS.ORGANIZATION_ID
, CZ_CONFIG_ITEMS.NODE_IDENTIFIER AS COMPONENT_CODE
, CZ_CONFIG_ITEMS.COMPONENT_SEQUENCE_ID
, CZ_CONFIG_ITEMS.ITEM_NUM_VAL AS QUANTITY
, CZ_CONFIG_ITEMS.UOM_CODE
, NVL(CZ_CONFIG_ITEMS.QUOTEABLE_FLAG
, '0') AS QUOTEABLE_FLAG
, CZ_CONFIG_ITEMS.BOM_ITEM_TYPE
, CZ_CONFIG_ITEMS.PS_NODE_ID
, CZ_CONFIG_ITEMS.USER_STR01
, CZ_CONFIG_ITEMS.USER_STR02
, CZ_CONFIG_ITEMS.USER_STR03
, CZ_CONFIG_ITEMS.USER_STR04
, CZ_CONFIG_ITEMS.USER_NUM01
, CZ_CONFIG_ITEMS.USER_NUM02
, CZ_CONFIG_ITEMS.USER_NUM03
, CZ_CONFIG_ITEMS.USER_NUM04
, CZ_CONFIG_ITEMS.BOM_SORT_ORDER
, CZ_CONFIG_ITEMS.INSTANCE_CONFIG_ITEM_ID AS MODEL_CONFIG_ITEM_ID
, CZ_CONFIG_ITEMS.ATO_CONFIG_ITEM_ID
, CZ_CONFIG_ITEMS.NAME
, CZ_CONFIG_ITEMS.INSTANCE_HDR_ID
, CZ_CONFIG_ITEMS.INSTANCE_REV_NBR
, CZ_CONFIG_ITEMS.LINE_TYPE
, CZ_CONFIG_ITEMS.COMPONENT_INSTANCE_TYPE
, CZ_CONFIG_ITEMS.TARGET_HDR_ID
, CZ_CONFIG_ITEMS.TARGET_REV_NBR
, CZ_CONFIG_ITEMS.CONFIG_DELTA
, CZ_CONFIG_ITEMS.LOCATION_ID
, CZ_CONFIG_ITEMS.LOCATION_TYPE_CODE
, CZ_CONFIG_ITEMS.IB_TRACKABLE
, CZ_CONFIG_ITEMS.EXT_ACTIVATED_FLAG
, CZ_CONFIG_HDRS.MODEL_INSTANTIATION_TYPE
, CZ_CONFIG_ITEMS.DISCONTINUED_FLAG
, CZ_CONFIG_ITEMS.ITEM_SRC_APPL_ID
, CZ_CONFIG_ITEMS.TANGIBLE_ITEM_FLAG
, CZ_CONFIG_ITEMS.RETURNED_FLAG
FROM CZ_CONFIG_HDRS
, CZ_CONFIG_ITEMS
WHERE CZ_CONFIG_ITEMS.DELETED_FLAG = '0'
AND CZ_CONFIG_HDRS.DELETED_FLAG = '0'
AND CZ_CONFIG_ITEMS.INVENTORY_ITEM_ID IS NOT NULL
AND CZ_CONFIG_ITEMS.ORGANIZATION_ID IS NOT NULL
AND CZ_CONFIG_ITEMS.ITEM_NUM_VAL IS NOT NULL
AND NVL(CZ_CONFIG_ITEMS.ITEM_NUM_VAL
, -1) > 0
AND (CZ_CONFIG_HDRS.CONFIG_DELTA_SPEC <= CZ_CONFIG_ITEMS.CONFIG_DELTA OR CZ_CONFIG_ITEMS.EXT_ACTIVATED_FLAG = '1')
AND CZ_CONFIG_HDRS.CONFIG_HDR_ID = CZ_CONFIG_ITEMS.CONFIG_HDR_ID
AND CZ_CONFIG_HDRS.CONFIG_REV_NBR = CZ_CONFIG_ITEMS.CONFIG_REV_NBR

Columns