它的源程序是“#:\oracle\visappl\inv\11.5.0\forms\US\INVIDITM.fmx”。
数据来源:视图MTL_SYSTEM_ITEMS_FVL
来源的两张表MTL_SYSTEM_ITEMS_B
MTL_SYSTEM_ITEMS_TL
操作数据:
CREATE OR REPLACE VIEW "APPS"."MTL_SYSTEM_ITEMS_FVL"
(
"ROW_ID",
"INVENTORY_ITEM_ID","ORGANIZATION_ID",
"PRIMARY_UOM_CODE",
"PRIMARY_UNIT_OF_MEASURE",
"ITEM_TYPE",
"INVENTORY_ITEM_STATUS_CODE",
"ALLOWED_UNITS_LOOKUP_CODE",
"ITEM_CATALOG_GROUP_ID",
"CATALOG_STATUS_FLAG",
"INVENTORY_ITEM_FLAG",
"STOCK_ENABLED_FLAG",
"MTL_TRANSACTIONS_ENABLED_FLAG",
"CHECK_SHORTAGES_FLAG",
"REVISION_QTY_CONTROL_CODE",
"RESERVABLE_TYPE",
"SHELF_LIFE_CODE",
"SHELF_LIFE_DAYS",
"CYCLE_COUNT_ENABLED_FLAG",
"NEGATIVE_MEASUREMENT_ERROR",
"POSITIVE_MEASUREMENT_ERROR",
"LOT_CONTROL_CODE",
"AUTO_LOT_ALPHA_PREFIX",
"START_AUTO_LOT_NUMBER",
"SERIAL_NUMBER_CONTROL_CODE",
"AUTO_SERIAL_ALPHA_PREFIX",
"START_AUTO_SERIAL_NUMBER",
"LOCATION_CONTROL_CODE",
"RESTRICT_SUBINVENTORIES_CODE",
"RESTRICT_LOCATORS_CODE",
"BOM_ENABLED_FLAG",
"BOM_ITEM_TYPE",
"BASE_ITEM_ID",
"EFFECTIVITY_CONTROL",
"ENG_ITEM_FLAG",
"ENGINEERING_ECN_CODE",
"ENGINEERING_ITEM_ID",
"ENGINEERING_DATE",
"PRODUCT_FAMILY_ITEM_ID",
"AUTO_CREATED_CONFIG_FLAG",
"MODEL_CONFIG_CLAUSE_NAME",
"NEW_REVISION_CODE",
"COSTING_ENABLED_FLAG",
"INVENTORY_ASSET_FLAG",
"DEFAULT_INCLUDE_IN_ROLLUP_FLAG",
"COST_OF_SALES_ACCOUNT",
"STD_LOT_SIZE",
"PURCHASING_ITEM_FLAG",
"PURCHASING_ENABLED_FLAG",
"MUST_USE_APPROVED_VENDOR_FLAG",
"ALLOW_ITEM_DESC_UPDATE_FLAG",
"RFQ_REQUIRED_FLAG",
"OUTSIDE_OPERATION_FLAG",
"OUTSIDE_OPERATION_UOM_TYPE",
"TAXABLE_FLAG",
"PURCHASING_TAX_CODE",
"RECEIPT_REQUIRED_FLAG",
"INSPECTION_REQUIRED_FLAG",
"BUYER_ID",
"UNIT_OF_ISSUE",
"RECEIVE_CLOSE_TOLERANCE",
"INVOICE_CLOSE_TOLERANCE",
"UN_NUMBER_ID",
"HAZARD_CLASS_ID",
"LIST_PRICE_PER_UNIT",
"MARKET_PRICE",
"PRICE_TOLERANCE_PERCENT",
"ROUNDING_FACTOR",
"ENCUMBRANCE_ACCOUNT",
"EXPENSE_ACCOUNT",
"ASSET_CATEGORY_ID",
"RECEIPT_DAYS_EXCEPTION_CODE","DAYS_EARLY_RECEIPT_ALLOWED",
"DAYS_LATE_RECEIPT_ALLOWED",
"ALLOW_SUBSTITUTE_RECEIPTS_FLAG",
"ALLOW_UNORDERED_RECEIPTS_FLAG",
"ALLOW_EXPRESS_DELIVERY_FLAG",
"QTY_RCV_EXCEPTION_CODE",
"QTY_RCV_TOLERANCE",
"RECEIVING_ROUTING_ID",
"ENFORCE_SHIP_TO_LOCATION_CODE",
"WEIGHT_UOM_CODE",
"UNIT_WEIGHT",
"VOLUME_UOM_CODE",
"UNIT_VOLUME",
"CONTAINER_ITEM_FLAG",
"VEHICLE_ITEM_FLAG",
"CONTAINER_TYPE_CODE",
"INTERNAL_VOLUME",
"MAXIMUM_LOAD_WEIGHT",
"MINIMUM_FILL_PERCENT",
"INVENTORY_PLANNING_CODE",
"PLANNER_CODE",
"PLANNING_MAKE_BUY_CODE",
"MIN_MINMAX_QUANTITY",
"MAX_MINMAX_QUANTITY",
"MINIMUM_ORDER_QUANTITY",
"MAXIMUM_ORDER_QUANTITY",
"ORDER_COST",
"CARRYING_COST",
"SOURCE_TYPE",
"SOURCE_ORGANIZATION_ID",
"SOURCE_SUBINVENTORY",
"MRP_SAFETY_STOCK_CODE",
"SAFETY_STOCK_BUCKET_DAYS",
"MRP_SAFETY_STOCK_PERCENT",
"FIXED_ORDER_QUANTITY",
"FIXED_DAYS_SUPPLY",
"FIXED_LOT_MULTIPLIER",
"MRP_PLANNING_CODE",
"ATO_FORECAST_CONTROL",
"PLANNING_EXCEPTION_SET",
"END_ASSEMBLY_PEGGING_FLAG",
"SHRINKAGE_RATE",
"ROUNDING_CONTROL_TYPE",
"ACCEPTABLE_EARLY_DAYS",
"REPETITIVE_PLANNING_FLAG",
"OVERRUN_PERCENTAGE",
"ACCEPTABLE_RATE_INCREASE",
"ACCEPTABLE_RATE_DECREASE",
"MRP_CALCULATE_ATP_FLAG",
"AUTO_REDUCE_MPS",
"PLANNING_TIME_FENCE_CODE",
"PLANNING_TIME_FENCE_DAYS",
"DEMAND_TIME_FENCE_CODE",
"DEMAND_TIME_FENCE_DAYS",
"RELEASE_TIME_FENCE_CODE",
"RELEASE_TIME_FENCE_DAYS",
"PREPROCESSING_LEAD_TIME",
"FULL_LEAD_TIME",
"POSTPROCESSING_LEAD_TIME",
"FIXED_LEAD_TIME",
"VARIABLE_LEAD_TIME",
"CUM_MANUFACTURING_LEAD_TIME",
"CUMULATIVE_TOTAL_LEAD_TIME",
"LEAD_TIME_LOT_SIZE",
"BUILD_IN_WIP_FLAG",
"WIP_SUPPLY_TYPE",
"WIP_SUPPLY_SUBINVENTORY",
"WIP_SUPPLY_LOCATOR_ID",
"OVERCOMPLETION_TOLERANCE_TYPE",
"OVERCOMPLETION_TOLERANCE_VALUE","CUSTOMER_ORDER_FLAG",
"CUSTOMER_ORDER_ENABLED_FLAG",
"SHIPPABLE_ITEM_FLAG",
"INTERNAL_ORDER_FLAG",
"INTERNAL_ORDER_ENABLED_FLAG",
"SO_TRANSACTIONS_FLAG",
"PICK_COMPONENTS_FLAG",
"ATP_FLAG",
"REPLENISH_TO_ORDER_FLAG",
"ATP_RULE_ID",
"ATP_COMPONENTS_FLAG",
"SHIP_MODEL_COMPLETE_FLAG",
"PICKING_RULE_ID",
"COLLATERAL_FLAG",
"DEFAULT_SHIPPING_ORG",
"RETURNABLE_FLAG",
"RETURN_INSPECTION_REQUIREMENT",
"OVER_SHIPMENT_TOLERANCE",
"UNDER_SHIPMENT_TOLERANCE",
"OVER_RETURN_TOLERANCE",
"UNDER_RETURN_TOLERANCE",
"INVOICEABLE_ITEM_FLAG",
"INVOICE_ENABLED_FLAG",
"ACCOUNTING_RULE_ID",
"INVOICING_RULE_ID",
"TAX_CODE",
"SALES_ACCOUNT",
"PAYMENT_TERMS_ID",
"SERVICE_ITEM_FLAG",
"VENDOR_WARRANTY_FLAG",
"COVERAGE_SCHEDULE_ID",
"SERVICE_DURATION",
"SERVICE_DURATION_PERIOD_CODE",
"SERVICEABLE_PRODUCT_FLAG",
"SERVICE_STARTING_DELAY",
"MATERIAL_BILLABLE_FLAG",
"TIME_BILLABLE_FLAG",
"EXPENSE_BILLABLE_FLAG",
"SERVICEABLE_COMPONENT_FLAG",
"PREVENTIVE_MAINTENANCE_FLAG",
"PRORATE_SERVICE_FLAG",
"SERVICEABLE_ITEM_CLASS_ID",
"BASE_WARRANTY_SERVICE_ID",
"WARRANTY_VENDOR_ID",
"MAX_WARRANTY_AMOUNT",
"RESPONSE_TIME_PERIOD_CODE",
"RESPONSE_TIME_VALUE",
"PRIMARY_SPECIALIST_ID",
"SECONDARY_SPECIALIST_ID",
"WH_UPDATE_DATE",
"SEGMENT1",
"SEGMENT2",
"SEGMENT3",
"SEGMENT4",
"SEGMENT5",
"SEGMENT6",
"SEGMENT7",
"SEGMENT8",
"SEGMENT9",
"SEGMENT10",
"SEGMENT11",
"SEGMENT12",
"SEGMENT13",
"SEGMENT14",
"SEGMENT15",
"SEGMENT16",
"SEGMENT17",
"SEGMENT18",
"SEGMENT19",
"SEGMENT20","SUMMARY_FLAG",
"ENABLED_FLAG",
"START_DATE_ACTIVE",
"END_DATE_ACTIVE",
"ATTRIBUTE_CATEGORY",
"ATTRIBUTE1",
"ATTRIBUTE2",
"ATTRIBUTE3",
"ATTRIBUTE4",
"ATTRIBUTE5",
"ATTRIBUTE6",
"ATTRIBUTE7",
"ATTRIBUTE8",
"ATTRIBUTE9",
"ATTRIBUTE10",
"ATTRIBUTE11",
"ATTRIBUTE12",
"ATTRIBUTE13",
"ATTRIBUTE14",
"ATTRIBUTE15",
"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",
"CREATION_DATE",
"CREATED_BY",
"LAST_UPDATE_DATE",
"LAST_UPDATED_BY",
"LAST_UPDATE_LOGIN",
"REQUEST_ID",
"PROGRAM_APPLICATION_ID",
"PROGRAM_ID",
"PROGRAM_UPDATE_DATE",
"DESCRIPTION",
"LONG_DESCRIPTION")
AS 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.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.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
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')
数据解析:
MTL_SYSTEM_ITEMS_B
表中存放着库存、工程和采购物料的明细(物理属性和库存、应用状态) 主键
MTL_ SYSTEM_ITEMS_B_PK 组成字段:
INVENTORY_ITEM_ID
ORGANIZATION_ID
MTL_SYSTEM_ITEMS_TL
表中定义了MTL_SYSTEM_ITEM_B 表中字段的多语言说明,主键
MTL_SYSTEM_ITEMS_TL_PK
组成字段:
INVENTORY_ITEM_ID
ORGANIZATION_ID
LANGUAGE
相互关系是:
“MTL_SYSTEM_ITEMS_B”和“MTL_SYSTEM_ITEMS_TL”之间的关联是:
MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID
=MTL_SYSTEM_ITEMS_TL.INVENTORY_ITEM_ID