View: MTL_SYSTEM_ITEMS_FVL

Product:	INV - Inventory
Description:	Base view for the Define System Items (INVIDITM) form MTL_SYSTEM_ITEMS block. This view is MLS enabled.
Implementation/DBA Data:	APPS.MTL_SYSTEM_ITEMS_FVL

View Text

SELECT B.ROWID 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
, 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
, T.DESCRIPTION
, T.LONG_DESCRIPTION
, B.GDSN_OUTBOUND_ENABLED_FLAG
, B.TRADE_ITEM_DESCRIPTOR
, B.STYLE_ITEM_ID
, B.STYLE_ITEM_FLAG
, B.DEFAULT_MATERIAL_STATUS_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 B
WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND T.LANGUAGE = USERENV('LANG')

Columns