VIEW: APPS.OKX_CONFIG_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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