VIEW: APPS.OKX_CONFIG_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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