VIEW: APPS.MTL_SYSTEM_ITEMS_VL

Source

View Text - Preformatted

SELECT B.ROW_ID , B.INVENTORY_ITEM_ID , B.ORGANIZATION_ID , B.PRIMARY_UOM_CODE , B.PRIMARY_UNIT_OF_MEASURE , B.ITEM_TYPE , B.INVENTORY_ITEM_STATUS_CODE , B.ALLOWED_UNITS_LOOKUP_CODE , B.ITEM_CATALOG_GROUP_ID , B.CATALOG_STATUS_FLAG , B.INVENTORY_ITEM_FLAG , B.STOCK_ENABLED_FLAG , B.MTL_TRANSACTIONS_ENABLED_FLAG , B.CHECK_SHORTAGES_FLAG , B.REVISION_QTY_CONTROL_CODE , B.RESERVABLE_TYPE , B.SHELF_LIFE_CODE , B.SHELF_LIFE_DAYS , B.CYCLE_COUNT_ENABLED_FLAG , B.NEGATIVE_MEASUREMENT_ERROR , B.POSITIVE_MEASUREMENT_ERROR , B.LOT_CONTROL_CODE , B.AUTO_LOT_ALPHA_PREFIX , B.START_AUTO_LOT_NUMBER , B.SERIAL_NUMBER_CONTROL_CODE , B.AUTO_SERIAL_ALPHA_PREFIX , B.START_AUTO_SERIAL_NUMBER , B.LOCATION_CONTROL_CODE , B.RESTRICT_SUBINVENTORIES_CODE , B.RESTRICT_LOCATORS_CODE , B.BOM_ENABLED_FLAG , B.BOM_ITEM_TYPE , B.BASE_ITEM_ID , B.EFFECTIVITY_CONTROL , B.ENG_ITEM_FLAG , B.ENGINEERING_ECN_CODE , B.ENGINEERING_ITEM_ID , B.ENGINEERING_DATE , B.PRODUCT_FAMILY_ITEM_ID , B.AUTO_CREATED_CONFIG_FLAG , B.MODEL_CONFIG_CLAUSE_NAME , B.NEW_REVISION_CODE , B.COSTING_ENABLED_FLAG , B.INVENTORY_ASSET_FLAG , B.DEFAULT_INCLUDE_IN_ROLLUP_FLAG , B.COST_OF_SALES_ACCOUNT , B.STD_LOT_SIZE , B.PURCHASING_ITEM_FLAG , B.PURCHASING_ENABLED_FLAG , B.MUST_USE_APPROVED_VENDOR_FLAG , B.ALLOW_ITEM_DESC_UPDATE_FLAG , B.RFQ_REQUIRED_FLAG , B.OUTSIDE_OPERATION_FLAG , B.OUTSIDE_OPERATION_UOM_TYPE , B.TAXABLE_FLAG , B.PURCHASING_TAX_CODE , B.RECEIPT_REQUIRED_FLAG , B.INSPECTION_REQUIRED_FLAG , B.BUYER_ID , B.UNIT_OF_ISSUE , B.RECEIVE_CLOSE_TOLERANCE , B.INVOICE_CLOSE_TOLERANCE , B.UN_NUMBER_ID , B.HAZARD_CLASS_ID , B.LIST_PRICE_PER_UNIT , B.MARKET_PRICE , B.PRICE_TOLERANCE_PERCENT , B.ROUNDING_FACTOR , B.ENCUMBRANCE_ACCOUNT , B.EXPENSE_ACCOUNT , B.ASSET_CATEGORY_ID , B.RECEIPT_DAYS_EXCEPTION_CODE , B.DAYS_EARLY_RECEIPT_ALLOWED , B.DAYS_LATE_RECEIPT_ALLOWED , B.ALLOW_SUBSTITUTE_RECEIPTS_FLAG , B.ALLOW_UNORDERED_RECEIPTS_FLAG , B.ALLOW_EXPRESS_DELIVERY_FLAG , B.QTY_RCV_EXCEPTION_CODE , B.QTY_RCV_TOLERANCE , B.RECEIVING_ROUTING_ID , B.ENFORCE_SHIP_TO_LOCATION_CODE , B.WEIGHT_UOM_CODE , B.UNIT_WEIGHT , B.VOLUME_UOM_CODE , B.UNIT_VOLUME , B.CONTAINER_ITEM_FLAG , B.VEHICLE_ITEM_FLAG , B.CONTAINER_TYPE_CODE , B.INTERNAL_VOLUME , B.MAXIMUM_LOAD_WEIGHT , B.MINIMUM_FILL_PERCENT , B.INVENTORY_PLANNING_CODE , B.PLANNER_CODE , B.PLANNING_MAKE_BUY_CODE , B.MIN_MINMAX_QUANTITY , B.MAX_MINMAX_QUANTITY , B.MINIMUM_ORDER_QUANTITY , B.MAXIMUM_ORDER_QUANTITY , B.ORDER_COST , B.CARRYING_COST , B.SOURCE_TYPE , B.SOURCE_ORGANIZATION_ID , B.SOURCE_SUBINVENTORY , B.MRP_SAFETY_STOCK_CODE , B.SAFETY_STOCK_BUCKET_DAYS , B.MRP_SAFETY_STOCK_PERCENT , B.FIXED_ORDER_QUANTITY , B.FIXED_DAYS_SUPPLY , B.FIXED_LOT_MULTIPLIER , B.MRP_PLANNING_CODE , B.ATO_FORECAST_CONTROL , B.PLANNING_EXCEPTION_SET , B.END_ASSEMBLY_PEGGING_FLAG , B.SHRINKAGE_RATE , B.ROUNDING_CONTROL_TYPE , B.ACCEPTABLE_EARLY_DAYS , B.REPETITIVE_PLANNING_FLAG , B.OVERRUN_PERCENTAGE , B.ACCEPTABLE_RATE_INCREASE , B.ACCEPTABLE_RATE_DECREASE , B.MRP_CALCULATE_ATP_FLAG , B.AUTO_REDUCE_MPS , B.PLANNING_TIME_FENCE_CODE , B.PLANNING_TIME_FENCE_DAYS , B.DEMAND_TIME_FENCE_CODE , B.DEMAND_TIME_FENCE_DAYS , B.RELEASE_TIME_FENCE_CODE , B.RELEASE_TIME_FENCE_DAYS , B.PREPROCESSING_LEAD_TIME , B.FULL_LEAD_TIME , B.POSTPROCESSING_LEAD_TIME , B.FIXED_LEAD_TIME , B.VARIABLE_LEAD_TIME , B.CUM_MANUFACTURING_LEAD_TIME , B.CUMULATIVE_TOTAL_LEAD_TIME , B.LEAD_TIME_LOT_SIZE , B.BUILD_IN_WIP_FLAG , B.WIP_SUPPLY_TYPE , B.WIP_SUPPLY_SUBINVENTORY , B.WIP_SUPPLY_LOCATOR_ID , B.OVERCOMPLETION_TOLERANCE_TYPE , B.OVERCOMPLETION_TOLERANCE_VALUE , B.CUSTOMER_ORDER_FLAG , B.CUSTOMER_ORDER_ENABLED_FLAG , B.SHIPPABLE_ITEM_FLAG , B.INTERNAL_ORDER_FLAG , B.INTERNAL_ORDER_ENABLED_FLAG , B.SO_TRANSACTIONS_FLAG , B.PICK_COMPONENTS_FLAG , B.ATP_FLAG , B.REPLENISH_TO_ORDER_FLAG , B.ATP_RULE_ID , B.ATP_COMPONENTS_FLAG , B.SHIP_MODEL_COMPLETE_FLAG , B.PICKING_RULE_ID , B.COLLATERAL_FLAG , B.DEFAULT_SHIPPING_ORG , B.RETURNABLE_FLAG , B.RETURN_INSPECTION_REQUIREMENT , B.OVER_SHIPMENT_TOLERANCE , B.UNDER_SHIPMENT_TOLERANCE , B.OVER_RETURN_TOLERANCE , B.UNDER_RETURN_TOLERANCE , B.INVOICEABLE_ITEM_FLAG , B.INVOICE_ENABLED_FLAG , B.ACCOUNTING_RULE_ID , B.INVOICING_RULE_ID , B.TAX_CODE , B.SALES_ACCOUNT , B.PAYMENT_TERMS_ID , B.SERVICE_ITEM_FLAG , B.VENDOR_WARRANTY_FLAG , B.COVERAGE_SCHEDULE_ID , B.SERVICE_DURATION , B.SERVICE_DURATION_PERIOD_CODE , B.SERVICEABLE_PRODUCT_FLAG , B.SERVICE_STARTING_DELAY , B.MATERIAL_BILLABLE_FLAG , B.TIME_BILLABLE_FLAG , B.EXPENSE_BILLABLE_FLAG , B.SERVICEABLE_COMPONENT_FLAG , B.PREVENTIVE_MAINTENANCE_FLAG , B.PRORATE_SERVICE_FLAG , B.SERVICEABLE_ITEM_CLASS_ID , B.BASE_WARRANTY_SERVICE_ID , B.WARRANTY_VENDOR_ID , B.MAX_WARRANTY_AMOUNT , B.RESPONSE_TIME_PERIOD_CODE , B.RESPONSE_TIME_VALUE , B.PRIMARY_SPECIALIST_ID , B.SECONDARY_SPECIALIST_ID , B.WH_UPDATE_DATE , B.SEGMENT1 , B.SEGMENT2 , B.SEGMENT3 , B.SEGMENT4 , B.SEGMENT5 , B.SEGMENT6 , B.SEGMENT7 , B.SEGMENT8 , B.SEGMENT9 , B.SEGMENT10 , B.SEGMENT11 , B.SEGMENT12 , B.SEGMENT13 , B.SEGMENT14 , B.SEGMENT15 , B.SEGMENT16 , B.SEGMENT17 , B.SEGMENT18 , B.SEGMENT19 , B.SEGMENT20 , B.SUMMARY_FLAG , B.ENABLED_FLAG , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , B.ATTRIBUTE_CATEGORY , B.ATTRIBUTE1 , B.ATTRIBUTE2 , B.ATTRIBUTE3 , B.ATTRIBUTE4 , B.ATTRIBUTE5 , B.ATTRIBUTE6 , B.ATTRIBUTE7 , B.ATTRIBUTE8 , B.ATTRIBUTE9 , B.ATTRIBUTE10 , B.ATTRIBUTE11 , B.ATTRIBUTE12 , B.ATTRIBUTE13 , B.ATTRIBUTE14 , B.ATTRIBUTE15 , b.attribute16 , b.attribute17 , b.attribute18 , b.attribute19 , b.attribute20 , b.attribute21 , b.attribute22 , b.attribute23 , b.attribute24 , b.attribute25 , b.attribute26 , b.attribute27 , b.attribute28 , b.attribute29 , b.attribute30 , B.GLOBAL_ATTRIBUTE_CATEGORY , B.GLOBAL_ATTRIBUTE1 , B.GLOBAL_ATTRIBUTE2 , B.GLOBAL_ATTRIBUTE3 , B.GLOBAL_ATTRIBUTE4 , B.GLOBAL_ATTRIBUTE5 , B.GLOBAL_ATTRIBUTE6 , B.GLOBAL_ATTRIBUTE7 , B.GLOBAL_ATTRIBUTE8 , B.GLOBAL_ATTRIBUTE9 , B.GLOBAL_ATTRIBUTE10 , B.EQUIPMENT_TYPE , B.RECOVERED_PART_DISP_CODE , B.DEFECT_TRACKING_ON_FLAG , B.USAGE_ITEM_FLAG , B.EVENT_FLAG , B.ELECTRONIC_FLAG , B.DOWNLOADABLE_FLAG , B.VOL_DISCOUNT_EXEMPT_FLAG , B.COUPON_EXEMPT_FLAG , B.COMMS_NL_TRACKABLE_FLAG , B.ASSET_CREATION_CODE , B.COMMS_ACTIVATION_REQD_FLAG , B.ORDERABLE_ON_WEB_FLAG , B.BACK_ORDERABLE_FLAG , B.WEB_STATUS , B.INDIVISIBLE_FLAG , B.DIMENSION_UOM_CODE , B.UNIT_LENGTH , B.UNIT_WIDTH , B.UNIT_HEIGHT , B.BULK_PICKED_FLAG , B.LOT_STATUS_ENABLED , B.DEFAULT_LOT_STATUS_ID , B.SERIAL_STATUS_ENABLED , B.DEFAULT_SERIAL_STATUS_ID , B.LOT_SPLIT_ENABLED , B.LOT_MERGE_ENABLED , B.INVENTORY_CARRY_PENALTY , B.OPERATION_SLACK_PENALTY , B.FINANCING_ALLOWED_FLAG , B.EAM_ITEM_TYPE , B.EAM_ACTIVITY_TYPE_CODE , B.EAM_ACTIVITY_CAUSE_CODE , B.EAM_ACT_NOTIFICATION_FLAG , B.EAM_ACT_SHUTDOWN_STATUS , B.DUAL_UOM_CONTROL , B.SECONDARY_UOM_CODE , B.DUAL_UOM_DEVIATION_HIGH , B.DUAL_UOM_DEVIATION_LOW , B.CONTRACT_ITEM_TYPE_CODE , B.SUBSCRIPTION_DEPEND_FLAG , B.SERV_REQ_ENABLED_CODE , B.SERV_BILLING_ENABLED_FLAG , B.SERV_IMPORTANCE_LEVEL , B.PLANNED_INV_POINT_FLAG , B.LOT_TRANSLATE_ENABLED , B.DEFAULT_SO_SOURCE_TYPE , B.CREATE_SUPPLY_FLAG , B.SUBSTITUTION_WINDOW_CODE , B.SUBSTITUTION_WINDOW_DAYS , B.IB_ITEM_INSTANCE_CLASS , B.CONFIG_MODEL_TYPE , B.LOT_SUBSTITUTION_ENABLED , B.MINIMUM_LICENSE_QUANTITY , B.EAM_ACTIVITY_SOURCE_CODE , B.LIFECYCLE_ID , B.CURRENT_PHASE_ID , B.OBJECT_VERSION_NUMBER , B.TRACKING_QUANTITY_IND , B.ONT_PRICING_QTY_SOURCE , B.SECONDARY_DEFAULT_IND , B.OPTION_SPECIFIC_SOURCED , B.APPROVAL_STATUS , B.VMI_MINIMUM_UNITS , B.VMI_MINIMUM_DAYS , B.VMI_MAXIMUM_UNITS , B.VMI_MAXIMUM_DAYS , B.VMI_FIXED_ORDER_QUANTITY , B.SO_AUTHORIZATION_FLAG , B.CONSIGNED_FLAG , B.ASN_AUTOEXPIRE_FLAG , B.VMI_FORECAST_TYPE , B.FORECAST_HORIZON , B.EXCLUDE_FROM_BUDGET_FLAG , B.DAYS_TGT_INV_SUPPLY , B.DAYS_TGT_INV_WINDOW , B.DAYS_MAX_INV_SUPPLY , B.DAYS_MAX_INV_WINDOW , B.DRP_PLANNED_FLAG , B.CRITICAL_COMPONENT_FLAG , B.CONTINOUS_TRANSFER , B.CONVERGENCE , B.DIVERGENCE , B.CONFIG_ORGS , B.CONFIG_MATCH , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN , B.REQUEST_ID , B.PROGRAM_APPLICATION_ID , B.PROGRAM_ID , B.PROGRAM_UPDATE_DATE , T.DESCRIPTION , T.LONG_DESCRIPTION , B.CONCATENATED_SEGMENTS , B.PADDED_CONCATENATED_SEGMENTS , b.lot_divisible_flag, b.grade_control_flag, b.default_grade, b.child_lot_flag, b.parent_child_generation_flag, b.child_lot_prefix, b.child_lot_starting_number, b.child_lot_validation_flag, b.copy_lot_attribute_flag, b.recipe_enabled_flag, b.process_costing_enabled_flag, b.retest_interval, b.expiration_action_interval, b.expiration_action_code, b.maturity_days, b.hold_days , b.process_quality_enabled_flag , b.process_execution_enabled_flag , b.process_supply_subinventory , b.process_supply_locator_id , b.process_yield_subinventory , b.process_yield_locator_id , b.hazardous_material_flag , b.cas_number , B.CHARGE_PERIODICITY_CODE, B.REPAIR_LEADTIME, B.REPAIR_YIELD, B.PREPOSITION_POINT, B.REPAIR_PROGRAM, B.SUBCONTRACTING_COMPONENT, B.OUTSOURCED_ASSEMBLY, B.GDSN_OUTBOUND_ENABLED_FLAG, B.TRADE_ITEM_DESCRIPTOR, B.STYLE_ITEM_ID, B.STYLE_ITEM_FLAG, B.LAST_SUBMITTED_NIR_ID , B.GLOBAL_ATTRIBUTE11 , B.GLOBAL_ATTRIBUTE12 , B.GLOBAL_ATTRIBUTE13 , B.GLOBAL_ATTRIBUTE14 , B.GLOBAL_ATTRIBUTE15 , B.GLOBAL_ATTRIBUTE16 , B.GLOBAL_ATTRIBUTE17 , B.GLOBAL_ATTRIBUTE18 , B.GLOBAL_ATTRIBUTE19 , B.GLOBAL_ATTRIBUTE20 FROM MTL_SYSTEM_ITEMS_TL T , MTL_SYSTEM_ITEMS_B_KFV B WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

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