VIEW: APPS.MTL_SYSTEM_ITEMS_B_KFV

Source

View Text - Preformatted

SELECT ROWID, INVENTORY_ITEM_ID, ORGANIZATION_ID,  
 SEGMENT1,  
 RPAD(NVL(SEGMENT1, ' '), 40),  
 COPY_LOT_ATTRIBUTE_FLAG, DIMENSION_UOM_CODE, UNIT_WIDTH, DEFECT_TRACKING_ON_FLAG, ATTRIBUTE14, MIN_MINMAX_QUANTITY, CARRYING_COST, LAST_SUBMITTED_NIR_ID, RESPONSE_TIME_VALUE, CHILD_LOT_STARTING_NUMBER, MODEL_CONFIG_CLAUSE_NAME, SOURCE_TYPE, LAST_UPDATE_DATE, PROCESS_QUALITY_ENABLED_FLAG, DEFAULT_GRADE, MRP_CALCULATE_ATP_FLAG, ATTRIBUTE16, INVOICE_ENABLED_FLAG, GLOBAL_ATTRIBUTE5, SOURCE_ORGANIZATION_ID, RECEIVING_ROUTING_ID, EAM_ACTIVITY_TYPE_CODE, SHELF_LIFE_DAYS, HAZARD_CLASS_ID, LIST_PRICE_PER_UNIT, SEGMENT16, ENFORCE_SHIP_TO_LOCATION_CODE, SERV_BILLING_ENABLED_FLAG, EFFECTIVITY_CONTROL, ACCOUNTING_RULE_ID, INSPECTION_REQUIRED_FLAG, DIVERGENCE, SUBSCRIPTION_DEPEND_FLAG, QTY_RCV_EXCEPTION_CODE, ATP_COMPONENTS_FLAG, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE13, CONTINOUS_TRANSFER, RESERVABLE_TYPE, DAYS_TGT_INV_SUPPLY, HOLD_DAYS, GLOBAL_ATTRIBUTE18, ATTRIBUTE15, SEGMENT3, GLOBAL_ATTRIBUTE_CATEGORY, ATTRIBUTE27, DRP_PLANNED_FLAG, ORDER_COST, FULL_LEAD_TIME, MRP_PLANNING_CODE, SAFETY_STOCK_BUCKET_DAYS, ATTRIBUTE30, FIXED_LOT_MULTIPLIER, SUMMARY_FLAG, DAYS_TGT_INV_WINDOW, PICK_COMPONENTS_FLAG, ATTRIBUTE12, INDIVISIBLE_FLAG, SERVICE_ITEM_FLAG, MAX_MINMAX_QUANTITY, BASE_WARRANTY_SERVICE_ID, ONT_PRICING_QTY_SOURCE, RECIPE_ENABLED_FLAG, CREATION_DATE, FIXED_ORDER_QUANTITY, DEFAULT_MATERIAL_STATUS_ID, STOCK_ENABLED_FLAG, CHECK_SHORTAGES_FLAG, ASSET_CATEGORY_ID, BOM_ITEM_TYPE, ROUNDING_CONTROL_TYPE, AUTO_LOT_ALPHA_PREFIX, TRACKING_QUANTITY_IND, INVENTORY_ITEM_FLAG, ASN_AUTOEXPIRE_FLAG, RELEASE_TIME_FENCE_CODE, ATTRIBUTE23, BOM_ENABLED_FLAG, RFQ_REQUIRED_FLAG, CONFIG_MATCH, COLLATERAL_FLAG, NEW_REVISION_CODE, INTERNAL_ORDER_FLAG, ASSET_CREATION_CODE, ATTRIBUTE17, VARIABLE_LEAD_TIME, LIFECYCLE_ID, EGO_MASTER_ITEMS_DFF_CTX, DESCRIPTION, GLOBAL_ATTRIBUTE9, PROCESS_COSTING_ENABLED_FLAG, FIXED_DAYS_SUPPLY, ENCUMBRANCE_ACCOUNT, ACCEPTABLE_RATE_INCREASE, MAXIMUM_ORDER_QUANTITY, ENGINEERING_DATE, ATTRIBUTE13, ROUNDING_FACTOR, NEGATIVE_MEASUREMENT_ERROR, INVOICE_CLOSE_TOLERANCE, SERVICEABLE_ITEM_CLASS_ID, SEGMENT5, SEGMENT19, CRITICAL_COMPONENT_FLAG, COST_OF_SALES_ACCOUNT, COSTING_ENABLED_FLAG, CUMULATIVE_TOTAL_LEAD_TIME, EXPENSE_ACCOUNT, ATTRIBUTE4, ACCEPTABLE_RATE_DECREASE, PRICE_TOLERANCE_PERCENT, DEFAULT_SERIAL_STATUS_ID, CONSIGNED_FLAG, DOWNLOADABLE_FLAG, WIP_SUPPLY_TYPE, INVOICING_RULE_ID, CHILD_LOT_FLAG, UN_NUMBER_ID, TRADE_ITEM_DESCRIPTOR, ATTRIBUTE8, SEGMENT6, VENDOR_WARRANTY_FLAG, VMI_MAXIMUM_DAYS, ORDERABLE_ON_WEB_FLAG, CATALOG_STATUS_FLAG, COVERAGE_SCHEDULE_ID, REPETITIVE_PLANNING_FLAG, ITEM_CATALOG_GROUP_ID, MRP_SAFETY_STOCK_PERCENT, LOT_SPLIT_ENABLED, VMI_MINIMUM_UNITS, PLANNED_INV_POINT_FLAG, SEGMENT11, OPERATION_SLACK_PENALTY, GLOBAL_ATTRIBUTE14, ATTRIBUTE_CATEGORY, PROCESS_YIELD_SUBINVENTORY, INTERNAL_ORDER_ENABLED_FLAG, SHRINKAGE_RATE, EQUIPMENT_TYPE, ENG_ITEM_FLAG, STD_LOT_SIZE, ACCEPTABLE_EARLY_DAYS, POSITIVE_MEASUREMENT_ERROR, LOCATION_CONTROL_CODE, RESTRICT_SUBINVENTORIES_CODE, SEGMENT15, WIP_SUPPLY_LOCATOR_ID, VMI_MAXIMUM_UNITS, EAM_ACTIVITY_CAUSE_CODE, CUM_MANUFACTURING_LEAD_TIME, SERVICE_DURATION_PERIOD_CODE, SHELF_LIFE_CODE, DAYS_LATE_RECEIPT_ALLOWED, ENABLED_FLAG, ATTRIBUTE28, IB_ITEM_INSTANCE_CLASS, WEB_STATUS, MRP_SAFETY_STOCK_CODE, RELEASE_TIME_FENCE_DAYS, PURCHASING_TAX_CODE, ITEM_TYPE, SERIAL_NUMBER_CONTROL_CODE, MATERIAL_BILLABLE_FLAG, REVISION_QTY_CONTROL_CODE, CHARGE_PERIODICITY_CODE, ATTRIBUTE11, OUTSOURCED_ASSEMBLY, WH_UPDATE_DATE, PLANNING_TIME_FENCE_DAYS, PAYMENT_TERMS_ID, REPAIR_YIELD, VOLUME_UOM_CODE, SEGMENT1, OVER_RETURN_TOLERANCE, PREVENTIVE_MAINTENANCE_FLAG, ATTRIBUTE10, ATTRIBUTE25, HAZARDOUS_MATERIAL_FLAG, UNIT_HEIGHT, SERVICE_DURATION, PREPOSITION_POINT, GLOBAL_ATTRIBUTE11, INTERNAL_VOLUME, COMMS_ACTIVATION_REQD_FLAG, RECOVERED_PART_DISP_CODE, MINIMUM_ORDER_QUANTITY, GLOBAL_ATTRIBUTE12, PURCHASING_ENABLED_FLAG, INVENTORY_CARRY_PENALTY, BACK_ORDERABLE_FLAG, GLOBAL_ATTRIBUTE17, SEGMENT8, SUBSTITUTION_WINDOW_DAYS, DEMAND_TIME_FENCE_DAYS, SEGMENT2, ALLOWED_UNITS_LOOKUP_CODE, SEGMENT17, CUSTOMER_ORDER_ENABLED_FLAG, VOL_DISCOUNT_EXEMPT_FLAG, ATTRIBUTE1, DEFAULT_LOT_STATUS_ID, CONFIG_MODEL_TYPE, ALLOW_SUBSTITUTE_RECEIPTS_FLAG, STYLE_ITEM_ID, AUTO_SERIAL_ALPHA_PREFIX, EAM_ACT_SHUTDOWN_STATUS, RETURN_INSPECTION_REQUIREMENT, WIP_SUPPLY_SUBINVENTORY, GDSN_OUTBOUND_ENABLED_FLAG, DUAL_UOM_CONTROL, GLOBAL_ATTRIBUTE19, OVERRUN_PERCENTAGE, TAX_CODE, SHIP_MODEL_COMPLETE_FLAG, INVENTORY_ITEM_STATUS_CODE, GLOBAL_ATTRIBUTE4, SO_AUTHORIZATION_FLAG, WEIGHT_UOM_CODE, CREATE_SUPPLY_FLAG, SOURCE_SUBINVENTORY, ATTRIBUTE9, SALES_ACCOUNT, SERIAL_STATUS_ENABLED, GLOBAL_ATTRIBUTE7, MATURITY_DAYS, START_DATE_ACTIVE, PLANNING_MAKE_BUY_CODE, RECEIPT_DAYS_EXCEPTION_CODE, APPROVAL_STATUS, ATP_FLAG, INVENTORY_ASSET_FLAG, PROGRAM_UPDATE_DATE, RETURNABLE_FLAG, MAX_WARRANTY_AMOUNT, ATTRIBUTE24, CONTAINER_ITEM_FLAG, START_AUTO_SERIAL_NUMBER, RECEIVE_CLOSE_TOLERANCE, MINIMUM_FILL_PERCENT, DEFAULT_SO_SOURCE_TYPE, BUYER_ID, SEGMENT20, AUTO_REDUCE_MPS, CAS_NUMBER, UNDER_SHIPMENT_TOLERANCE, EAM_ACTIVITY_SOURCE_CODE, OPTION_SPECIFIC_SOURCED, DUAL_UOM_DEVIATION_HIGH, LOT_MERGE_ENABLED, ATO_FORECAST_CONTROL, SEGMENT12, LEAD_TIME_LOT_SIZE, REQUEST_ID, ATTRIBUTE2, GLOBAL_ATTRIBUTE1, LOT_CONTROL_CODE, GLOBAL_ATTRIBUTE15, EAM_ACT_NOTIFICATION_FLAG, LAST_UPDATED_BY, PRODUCT_FAMILY_ITEM_ID, ATTRIBUTE29, GLOBAL_ATTRIBUTE6, UNDER_RETURN_TOLERANCE, LAST_UPDATE_LOGIN, EVENT_FLAG, PROCESS_EXECUTION_ENABLED_FLAG, PROCESS_SUPPLY_SUBINVENTORY, ATTRIBUTE21, REPAIR_PROGRAM, REPAIR_LEADTIME, SEGMENT10, CURRENT_PHASE_ID, REPLENISH_TO_ORDER_FLAG, EXPIRATION_ACTION_CODE, SERV_REQ_ENABLED_CODE, BUILD_IN_WIP_FLAG, COMMS_NL_TRACKABLE_FLAG, LOT_SUBSTITUTION_ENABLED, SERVICE_STARTING_DELAY, CREATED_BY, USAGE_ITEM_FLAG, SHIPPABLE_ITEM_FLAG, MTL_TRANSACTIONS_ENABLED_FLAG, GLOBAL_ATTRIBUTE8, PRORATE_SERVICE_FLAG, ATTRIBUTE26, RESTRICT_LOCATORS_CODE, GLOBAL_ATTRIBUTE3, DUAL_UOM_DEVIATION_LOW, UNIT_OF_ISSUE, ATTRIBUTE6, ENGINEERING_ECN_CODE, SECONDARY_UOM_CODE, SUBSTITUTION_WINDOW_CODE, SECONDARY_DEFAULT_IND, PRIMARY_SPECIALIST_ID, PROGRAM_ID, DEMAND_TIME_FENCE_CODE, ELECTRONIC_FLAG, PROCESS_SUPPLY_LOCATOR_ID, QTY_RCV_TOLERANCE, PROCESS_YIELD_LOCATOR_ID, CONFIG_ORGS, VMI_FORECAST_TYPE, PARENT_CHILD_GENERATION_FLAG, LOT_DIVISIBLE_FLAG, COUPON_EXEMPT_FLAG, SERVICEABLE_PRODUCT_FLAG, ENGINEERING_ITEM_ID, TIME_BILLABLE_FLAG, VMI_MINIMUM_DAYS, OBJECT_VERSION_NUMBER, SEGMENT9, START_AUTO_LOT_NUMBER, CONTAINER_TYPE_CODE, MINIMUM_LICENSE_QUANTITY, WARRANTY_VENDOR_ID, GLOBAL_ATTRIBUTE20, PICKING_RULE_ID, VEHICLE_ITEM_FLAG, SEGMENT18, ATTRIBUTE7, BASE_ITEM_ID, SECONDARY_SPECIALIST_ID, PURCHASING_ITEM_FLAG, FINANCING_ALLOWED_FLAG, ATP_RULE_ID, EXCLUDE_FROM_BUDGET_FLAG, ATTRIBUTE19, FIXED_LEAD_TIME, DEFAULT_SHIPPING_ORG, ATTRIBUTE20, POSTPROCESSING_LEAD_TIME, LOT_STATUS_ENABLED, EAM_ITEM_TYPE, DAYS_MAX_INV_WINDOW, RESPONSE_TIME_PERIOD_CODE, SERVICEABLE_COMPONENT_FLAG, DAYS_MAX_INV_SUPPLY, OUTSIDE_OPERATION_FLAG, MARKET_PRICE, OVERCOMPLETION_TOLERANCE_VALUE, PRIMARY_UOM_CODE, RECEIPT_REQUIRED_FLAG, PROGRAM_APPLICATION_ID, PLANNER_CODE, END_DATE_ACTIVE, MAXIMUM_LOAD_WEIGHT, INVOICEABLE_ITEM_FLAG, SO_TRANSACTIONS_FLAG, ATTRIBUTE22, SEGMENT7, SEGMENT14, ALLOW_UNORDERED_RECEIPTS_FLAG, ATTRIBUTE5, STYLE_ITEM_FLAG, OVERCOMPLETION_TOLERANCE_TYPE, PLANNING_EXCEPTION_SET, SERV_IMPORTANCE_LEVEL, GLOBAL_ATTRIBUTE10, EXPENSE_BILLABLE_FLAG, CONVERGENCE, ALLOW_EXPRESS_DELIVERY_FLAG, RETEST_INTERVAL, ALLOW_ITEM_DESC_UPDATE_FLAG, ATTRIBUTE18, GRADE_CONTROL_FLAG, CYCLE_COUNT_ENABLED_FLAG, CHILD_LOT_PREFIX, DAYS_EARLY_RECEIPT_ALLOWED, OUTSIDE_OPERATION_UOM_TYPE, VMI_FIXED_ORDER_QUANTITY, UNIT_VOLUME, LOT_TRANSLATE_ENABLED, AUTO_CREATED_CONFIG_FLAG, FORECAST_HORIZON, CUSTOMER_ORDER_FLAG, MUST_USE_APPROVED_VENDOR_FLAG, END_ASSEMBLY_PEGGING_FLAG, BULK_PICKED_FLAG, SEGMENT4, CONTRACT_ITEM_TYPE_CODE, ATTRIBUTE3, DEFAULT_INCLUDE_IN_ROLLUP_FLAG, TAXABLE_FLAG, UNIT_WEIGHT, GLOBAL_ATTRIBUTE2, PREPROCESSING_LEAD_TIME, EXPIRATION_ACTION_INTERVAL, OVER_SHIPMENT_TOLERANCE, CHILD_LOT_VALIDATION_FLAG, SUBCONTRACTING_COMPONENT, PRIMARY_UNIT_OF_MEASURE, INVENTORY_PLANNING_CODE, SEGMENT13, UNIT_LENGTH, PLANNING_TIME_FENCE_CODE 
 FROM MTL_SYSTEM_ITEMS_B

View Text - HTML Formatted

SELECT ROWID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, SEGMENT1
, RPAD(NVL(SEGMENT1
, ' ')
, 40)
, COPY_LOT_ATTRIBUTE_FLAG
, DIMENSION_UOM_CODE
, UNIT_WIDTH
, DEFECT_TRACKING_ON_FLAG
, ATTRIBUTE14
, MIN_MINMAX_QUANTITY
, CARRYING_COST
, LAST_SUBMITTED_NIR_ID
, RESPONSE_TIME_VALUE
, CHILD_LOT_STARTING_NUMBER
, MODEL_CONFIG_CLAUSE_NAME
, SOURCE_TYPE
, LAST_UPDATE_DATE
, PROCESS_QUALITY_ENABLED_FLAG
, DEFAULT_GRADE
, MRP_CALCULATE_ATP_FLAG
, ATTRIBUTE16
, INVOICE_ENABLED_FLAG
, GLOBAL_ATTRIBUTE5
, SOURCE_ORGANIZATION_ID
, RECEIVING_ROUTING_ID
, EAM_ACTIVITY_TYPE_CODE
, SHELF_LIFE_DAYS
, HAZARD_CLASS_ID
, LIST_PRICE_PER_UNIT
, SEGMENT16
, ENFORCE_SHIP_TO_LOCATION_CODE
, SERV_BILLING_ENABLED_FLAG
, EFFECTIVITY_CONTROL
, ACCOUNTING_RULE_ID
, INSPECTION_REQUIRED_FLAG
, DIVERGENCE
, SUBSCRIPTION_DEPEND_FLAG
, QTY_RCV_EXCEPTION_CODE
, ATP_COMPONENTS_FLAG
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE13
, CONTINOUS_TRANSFER
, RESERVABLE_TYPE
, DAYS_TGT_INV_SUPPLY
, HOLD_DAYS
, GLOBAL_ATTRIBUTE18
, ATTRIBUTE15
, SEGMENT3
, GLOBAL_ATTRIBUTE_CATEGORY
, ATTRIBUTE27
, DRP_PLANNED_FLAG
, ORDER_COST
, FULL_LEAD_TIME
, MRP_PLANNING_CODE
, SAFETY_STOCK_BUCKET_DAYS
, ATTRIBUTE30
, FIXED_LOT_MULTIPLIER
, SUMMARY_FLAG
, DAYS_TGT_INV_WINDOW
, PICK_COMPONENTS_FLAG
, ATTRIBUTE12
, INDIVISIBLE_FLAG
, SERVICE_ITEM_FLAG
, MAX_MINMAX_QUANTITY
, BASE_WARRANTY_SERVICE_ID
, ONT_PRICING_QTY_SOURCE
, RECIPE_ENABLED_FLAG
, CREATION_DATE
, FIXED_ORDER_QUANTITY
, DEFAULT_MATERIAL_STATUS_ID
, STOCK_ENABLED_FLAG
, CHECK_SHORTAGES_FLAG
, ASSET_CATEGORY_ID
, BOM_ITEM_TYPE
, ROUNDING_CONTROL_TYPE
, AUTO_LOT_ALPHA_PREFIX
, TRACKING_QUANTITY_IND
, INVENTORY_ITEM_FLAG
, ASN_AUTOEXPIRE_FLAG
, RELEASE_TIME_FENCE_CODE
, ATTRIBUTE23
, BOM_ENABLED_FLAG
, RFQ_REQUIRED_FLAG
, CONFIG_MATCH
, COLLATERAL_FLAG
, NEW_REVISION_CODE
, INTERNAL_ORDER_FLAG
, ASSET_CREATION_CODE
, ATTRIBUTE17
, VARIABLE_LEAD_TIME
, LIFECYCLE_ID
, EGO_MASTER_ITEMS_DFF_CTX
, DESCRIPTION
, GLOBAL_ATTRIBUTE9
, PROCESS_COSTING_ENABLED_FLAG
, FIXED_DAYS_SUPPLY
, ENCUMBRANCE_ACCOUNT
, ACCEPTABLE_RATE_INCREASE
, MAXIMUM_ORDER_QUANTITY
, ENGINEERING_DATE
, ATTRIBUTE13
, ROUNDING_FACTOR
, NEGATIVE_MEASUREMENT_ERROR
, INVOICE_CLOSE_TOLERANCE
, SERVICEABLE_ITEM_CLASS_ID
, SEGMENT5
, SEGMENT19
, CRITICAL_COMPONENT_FLAG
, COST_OF_SALES_ACCOUNT
, COSTING_ENABLED_FLAG
, CUMULATIVE_TOTAL_LEAD_TIME
, EXPENSE_ACCOUNT
, ATTRIBUTE4
, ACCEPTABLE_RATE_DECREASE
, PRICE_TOLERANCE_PERCENT
, DEFAULT_SERIAL_STATUS_ID
, CONSIGNED_FLAG
, DOWNLOADABLE_FLAG
, WIP_SUPPLY_TYPE
, INVOICING_RULE_ID
, CHILD_LOT_FLAG
, UN_NUMBER_ID
, TRADE_ITEM_DESCRIPTOR
, ATTRIBUTE8
, SEGMENT6
, VENDOR_WARRANTY_FLAG
, VMI_MAXIMUM_DAYS
, ORDERABLE_ON_WEB_FLAG
, CATALOG_STATUS_FLAG
, COVERAGE_SCHEDULE_ID
, REPETITIVE_PLANNING_FLAG
, ITEM_CATALOG_GROUP_ID
, MRP_SAFETY_STOCK_PERCENT
, LOT_SPLIT_ENABLED
, VMI_MINIMUM_UNITS
, PLANNED_INV_POINT_FLAG
, SEGMENT11
, OPERATION_SLACK_PENALTY
, GLOBAL_ATTRIBUTE14
, ATTRIBUTE_CATEGORY
, PROCESS_YIELD_SUBINVENTORY
, INTERNAL_ORDER_ENABLED_FLAG
, SHRINKAGE_RATE
, EQUIPMENT_TYPE
, ENG_ITEM_FLAG
, STD_LOT_SIZE
, ACCEPTABLE_EARLY_DAYS
, POSITIVE_MEASUREMENT_ERROR
, LOCATION_CONTROL_CODE
, RESTRICT_SUBINVENTORIES_CODE
, SEGMENT15
, WIP_SUPPLY_LOCATOR_ID
, VMI_MAXIMUM_UNITS
, EAM_ACTIVITY_CAUSE_CODE
, CUM_MANUFACTURING_LEAD_TIME
, SERVICE_DURATION_PERIOD_CODE
, SHELF_LIFE_CODE
, DAYS_LATE_RECEIPT_ALLOWED
, ENABLED_FLAG
, ATTRIBUTE28
, IB_ITEM_INSTANCE_CLASS
, WEB_STATUS
, MRP_SAFETY_STOCK_CODE
, RELEASE_TIME_FENCE_DAYS
, PURCHASING_TAX_CODE
, ITEM_TYPE
, SERIAL_NUMBER_CONTROL_CODE
, MATERIAL_BILLABLE_FLAG
, REVISION_QTY_CONTROL_CODE
, CHARGE_PERIODICITY_CODE
, ATTRIBUTE11
, OUTSOURCED_ASSEMBLY
, WH_UPDATE_DATE
, PLANNING_TIME_FENCE_DAYS
, PAYMENT_TERMS_ID
, REPAIR_YIELD
, VOLUME_UOM_CODE
, SEGMENT1
, OVER_RETURN_TOLERANCE
, PREVENTIVE_MAINTENANCE_FLAG
, ATTRIBUTE10
, ATTRIBUTE25
, HAZARDOUS_MATERIAL_FLAG
, UNIT_HEIGHT
, SERVICE_DURATION
, PREPOSITION_POINT
, GLOBAL_ATTRIBUTE11
, INTERNAL_VOLUME
, COMMS_ACTIVATION_REQD_FLAG
, RECOVERED_PART_DISP_CODE
, MINIMUM_ORDER_QUANTITY
, GLOBAL_ATTRIBUTE12
, PURCHASING_ENABLED_FLAG
, INVENTORY_CARRY_PENALTY
, BACK_ORDERABLE_FLAG
, GLOBAL_ATTRIBUTE17
, SEGMENT8
, SUBSTITUTION_WINDOW_DAYS
, DEMAND_TIME_FENCE_DAYS
, SEGMENT2
, ALLOWED_UNITS_LOOKUP_CODE
, SEGMENT17
, CUSTOMER_ORDER_ENABLED_FLAG
, VOL_DISCOUNT_EXEMPT_FLAG
, ATTRIBUTE1
, DEFAULT_LOT_STATUS_ID
, CONFIG_MODEL_TYPE
, ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, STYLE_ITEM_ID
, AUTO_SERIAL_ALPHA_PREFIX
, EAM_ACT_SHUTDOWN_STATUS
, RETURN_INSPECTION_REQUIREMENT
, WIP_SUPPLY_SUBINVENTORY
, GDSN_OUTBOUND_ENABLED_FLAG
, DUAL_UOM_CONTROL
, GLOBAL_ATTRIBUTE19
, OVERRUN_PERCENTAGE
, TAX_CODE
, SHIP_MODEL_COMPLETE_FLAG
, INVENTORY_ITEM_STATUS_CODE
, GLOBAL_ATTRIBUTE4
, SO_AUTHORIZATION_FLAG
, WEIGHT_UOM_CODE
, CREATE_SUPPLY_FLAG
, SOURCE_SUBINVENTORY
, ATTRIBUTE9
, SALES_ACCOUNT
, SERIAL_STATUS_ENABLED
, GLOBAL_ATTRIBUTE7
, MATURITY_DAYS
, START_DATE_ACTIVE
, PLANNING_MAKE_BUY_CODE
, RECEIPT_DAYS_EXCEPTION_CODE
, APPROVAL_STATUS
, ATP_FLAG
, INVENTORY_ASSET_FLAG
, PROGRAM_UPDATE_DATE
, RETURNABLE_FLAG
, MAX_WARRANTY_AMOUNT
, ATTRIBUTE24
, CONTAINER_ITEM_FLAG
, START_AUTO_SERIAL_NUMBER
, RECEIVE_CLOSE_TOLERANCE
, MINIMUM_FILL_PERCENT
, DEFAULT_SO_SOURCE_TYPE
, BUYER_ID
, SEGMENT20
, AUTO_REDUCE_MPS
, CAS_NUMBER
, UNDER_SHIPMENT_TOLERANCE
, EAM_ACTIVITY_SOURCE_CODE
, OPTION_SPECIFIC_SOURCED
, DUAL_UOM_DEVIATION_HIGH
, LOT_MERGE_ENABLED
, ATO_FORECAST_CONTROL
, SEGMENT12
, LEAD_TIME_LOT_SIZE
, REQUEST_ID
, ATTRIBUTE2
, GLOBAL_ATTRIBUTE1
, LOT_CONTROL_CODE
, GLOBAL_ATTRIBUTE15
, EAM_ACT_NOTIFICATION_FLAG
, LAST_UPDATED_BY
, PRODUCT_FAMILY_ITEM_ID
, ATTRIBUTE29
, GLOBAL_ATTRIBUTE6
, UNDER_RETURN_TOLERANCE
, LAST_UPDATE_LOGIN
, EVENT_FLAG
, PROCESS_EXECUTION_ENABLED_FLAG
, PROCESS_SUPPLY_SUBINVENTORY
, ATTRIBUTE21
, REPAIR_PROGRAM
, REPAIR_LEADTIME
, SEGMENT10
, CURRENT_PHASE_ID
, REPLENISH_TO_ORDER_FLAG
, EXPIRATION_ACTION_CODE
, SERV_REQ_ENABLED_CODE
, BUILD_IN_WIP_FLAG
, COMMS_NL_TRACKABLE_FLAG
, LOT_SUBSTITUTION_ENABLED
, SERVICE_STARTING_DELAY
, CREATED_BY
, USAGE_ITEM_FLAG
, SHIPPABLE_ITEM_FLAG
, MTL_TRANSACTIONS_ENABLED_FLAG
, GLOBAL_ATTRIBUTE8
, PRORATE_SERVICE_FLAG
, ATTRIBUTE26
, RESTRICT_LOCATORS_CODE
, GLOBAL_ATTRIBUTE3
, DUAL_UOM_DEVIATION_LOW
, UNIT_OF_ISSUE
, ATTRIBUTE6
, ENGINEERING_ECN_CODE
, SECONDARY_UOM_CODE
, SUBSTITUTION_WINDOW_CODE
, SECONDARY_DEFAULT_IND
, PRIMARY_SPECIALIST_ID
, PROGRAM_ID
, DEMAND_TIME_FENCE_CODE
, ELECTRONIC_FLAG
, PROCESS_SUPPLY_LOCATOR_ID
, QTY_RCV_TOLERANCE
, PROCESS_YIELD_LOCATOR_ID
, CONFIG_ORGS
, VMI_FORECAST_TYPE
, PARENT_CHILD_GENERATION_FLAG
, LOT_DIVISIBLE_FLAG
, COUPON_EXEMPT_FLAG
, SERVICEABLE_PRODUCT_FLAG
, ENGINEERING_ITEM_ID
, TIME_BILLABLE_FLAG
, VMI_MINIMUM_DAYS
, OBJECT_VERSION_NUMBER
, SEGMENT9
, START_AUTO_LOT_NUMBER
, CONTAINER_TYPE_CODE
, MINIMUM_LICENSE_QUANTITY
, WARRANTY_VENDOR_ID
, GLOBAL_ATTRIBUTE20
, PICKING_RULE_ID
, VEHICLE_ITEM_FLAG
, SEGMENT18
, ATTRIBUTE7
, BASE_ITEM_ID
, SECONDARY_SPECIALIST_ID
, PURCHASING_ITEM_FLAG
, FINANCING_ALLOWED_FLAG
, ATP_RULE_ID
, EXCLUDE_FROM_BUDGET_FLAG
, ATTRIBUTE19
, FIXED_LEAD_TIME
, DEFAULT_SHIPPING_ORG
, ATTRIBUTE20
, POSTPROCESSING_LEAD_TIME
, LOT_STATUS_ENABLED
, EAM_ITEM_TYPE
, DAYS_MAX_INV_WINDOW
, RESPONSE_TIME_PERIOD_CODE
, SERVICEABLE_COMPONENT_FLAG
, DAYS_MAX_INV_SUPPLY
, OUTSIDE_OPERATION_FLAG
, MARKET_PRICE
, OVERCOMPLETION_TOLERANCE_VALUE
, PRIMARY_UOM_CODE
, RECEIPT_REQUIRED_FLAG
, PROGRAM_APPLICATION_ID
, PLANNER_CODE
, END_DATE_ACTIVE
, MAXIMUM_LOAD_WEIGHT
, INVOICEABLE_ITEM_FLAG
, SO_TRANSACTIONS_FLAG
, ATTRIBUTE22
, SEGMENT7
, SEGMENT14
, ALLOW_UNORDERED_RECEIPTS_FLAG
, ATTRIBUTE5
, STYLE_ITEM_FLAG
, OVERCOMPLETION_TOLERANCE_TYPE
, PLANNING_EXCEPTION_SET
, SERV_IMPORTANCE_LEVEL
, GLOBAL_ATTRIBUTE10
, EXPENSE_BILLABLE_FLAG
, CONVERGENCE
, ALLOW_EXPRESS_DELIVERY_FLAG
, RETEST_INTERVAL
, ALLOW_ITEM_DESC_UPDATE_FLAG
, ATTRIBUTE18
, GRADE_CONTROL_FLAG
, CYCLE_COUNT_ENABLED_FLAG
, CHILD_LOT_PREFIX
, DAYS_EARLY_RECEIPT_ALLOWED
, OUTSIDE_OPERATION_UOM_TYPE
, VMI_FIXED_ORDER_QUANTITY
, UNIT_VOLUME
, LOT_TRANSLATE_ENABLED
, AUTO_CREATED_CONFIG_FLAG
, FORECAST_HORIZON
, CUSTOMER_ORDER_FLAG
, MUST_USE_APPROVED_VENDOR_FLAG
, END_ASSEMBLY_PEGGING_FLAG
, BULK_PICKED_FLAG
, SEGMENT4
, CONTRACT_ITEM_TYPE_CODE
, ATTRIBUTE3
, DEFAULT_INCLUDE_IN_ROLLUP_FLAG
, TAXABLE_FLAG
, UNIT_WEIGHT
, GLOBAL_ATTRIBUTE2
, PREPROCESSING_LEAD_TIME
, EXPIRATION_ACTION_INTERVAL
, OVER_SHIPMENT_TOLERANCE
, CHILD_LOT_VALIDATION_FLAG
, SUBCONTRACTING_COMPONENT
, PRIMARY_UNIT_OF_MEASURE
, INVENTORY_PLANNING_CODE
, SEGMENT13
, UNIT_LENGTH
, PLANNING_TIME_FENCE_CODE
FROM MTL_SYSTEM_ITEMS_B