Product: | OKX - Contracts Integration |
---|---|
Description: | Items selected for the configuration |
Implementation/DBA Data: | APPS.OKX_CONFIG_ITEMS_V |
SELECT CFG.CONFIG_HDR_ID CONFIG_HDR_ID
, CFG.CONFIG_REV_NBR CONFIG_REV_NBR
, CFG.CONFIG_ITEM_ID CONFIG_ITEM_ID
, CFG.UOM_CODE UOM_CODE
, CFG.PS_NODE_ID PS_NODE_ID
, CFG.VALUE_TYPE_CODE VALUE_TYPE_CODE
, CFG.ROOT_BOM_CONFIG_ITEM_ID ROOT_BOM_CONFIG_ITEM_ID
, CFG.SEQUENCE_NBR SEQUENCE_NBR
, CFG.ITEM_VAL ITEM_VAL
, CFG.INSTANCE_NBR INSTANCE_NBR
, CFG.PARENT_CONFIG_ITEM_ID PARENT_CONFIG_ITEM_ID
, CFG.NODE_IDENTIFIER COMPONENT_CODE
, CFG.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CFG.ORGANIZATION_ID ORGANIZATION_ID
, CFG.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, CFG.DELETED_FLAG DELETED_FLAG
, CFG.EFF_FROM EFF_FROM
, CFG.EFF_TO EFF_TO
, CFG.SECURITY_MASK SECURITY_MASK
, CFG.EFF_MASK EFF_MASK
, CFG.CHECKOUT_USER CHECKOUT_USER
, CFG.USER_STR01 USER_STR01
, CFG.USER_STR02 USER_STR02
, CFG.USER_STR03 USER_STR03
, CFG.USER_STR04 USER_STR04
, CFG.USER_NUM01 USER_NUM01
, CFG.USER_NUM02 USER_NUM02
, CFG.USER_NUM03 USER_NUM03
, CFG.USER_NUM04 USER_NUM04
FROM CZ_CONFIG_ITEMS CFG