View: OKX_CONFIG_DETAILS_V

Product:	OKX - Contracts Integration
Description:	Configurator Details
Implementation/DBA Data:	APPS.OKX_CONFIG_DETAILS_V

View Text

SELECT CZCI.CONFIG_HDR_ID
, CZCI.CONFIG_REV_NBR
, CZCI.CONFIG_ITEM_ID
, CZCI.PARENT_CONFIG_ITEM_ID
, CZCI.INVENTORY_ITEM_ID
, CZCI.ORGANIZATION_ID
, CZCI.NODE_IDENTIFIER AS COMPONENT_CODE
, CZ_UTILS.CONV_NUM( DECODE(CZCI.VALUE_TYPE_CODE
, 3
, CZCI.ITEM_VAL
, NULL)
, '9999999999999999.99999999') AS QUANTITY
, CZCI.UOM_CODE
, CZCI.BOM_ITEM_TYPE
, CZCI.PS_NODE_ID
, CZCI.BOM_SORT_ORDER
FROM CZ_CONFIG_ITEMS CZCI
WHERE CZCI.DELETED_FLAG = '0'
AND CZCI.INVENTORY_ITEM_ID IS NOT NULL
AND CZCI.ORGANIZATION_ID IS NOT NULL
AND CZCI.ITEM_VAL IS NOT NULL
AND NVL(CZ_UTILS.CONV_NUM(CZCI.ITEM_VAL)
, -1) > 0

Columns