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