Oracle_ERP_库存管理INV_8个表结构下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_TRANSACTION_TYPES(TRANSACTION_TYPE_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,TRANSACTION_TYPE_NAME VARCHAR2(80) not null, DESCRIPTION VARCHAR2(240),TRANSACTION_ACTION_ID NUMBER not null, TRANSACTION_SOURCE_TYPE_ID NUMBER not null, SHORTAGE_MSG_BACKGROUND_FLAG VARCHAR2(1), SHORTAGE_MSG_ONLINE_FLAG VARCHAR2(1), DISABLE_DATE DATE,USER_DEFINED_FLAG VARCHAR2(1) not null, ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),ATTRIBUTE_CATEGORY VARCHAR2(30),TYPE_CLASS NUMBER,STATUS_CONTROL_FLAG NUMBER)tablespace APPS_TS_SEEDpctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_TRANSACTION_TYPES_N1 onINV.MTL_TRANSACTION_TYPES (TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID)tablespace APPS_TS_SEEDpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index INV.MTL_TRANSACTION_TYPES_U1 onINV.MTL_TRANSACTION_TYPES (TRANSACTION_TYPE_ID) tablespace APPS_TS_SEEDpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_TRANSACTION_TYPES to APPS with grant option;grant select on INV.MTL_TRANSACTION_TYPES to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_ID NUMBER not null, ORGANIZATION_ID NUMBER not null, LAST_UPDATE_DATE DATE not null, LAST_UPDATED_BY NUMBER not null, CREATION_DATE DATE not null, CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER, SUMMARY_FLAG VARCHAR2(1) not null, ENABLED_FLAG VARCHAR2(1) not null,START_DATE_ACTIVE DATE,END_DATE_ACTIVE DATE,DESCRIPTION VARCHAR2(240),BUYER_ID NUMBER(9),ACCOUNTING_RULE_ID NUMBER, INVOICING_RULE_ID NUMBER, SEGMENT1 VARCHAR2(40),SEGMENT2 VARCHAR2(40),SEGMENT3 VARCHAR2(40),SEGMENT4 VARCHAR2(40),SEGMENT5 VARCHAR2(40),SEGMENT6 VARCHAR2(40),SEGMENT7 VARCHAR2(40),SEGMENT8 VARCHAR2(40),SEGMENT9 VARCHAR2(40),SEGMENT10 VARCHAR2(40),SEGMENT11 VARCHAR2(40),SEGMENT12 VARCHAR2(40),SEGMENT13 VARCHAR2(40),SEGMENT14 VARCHAR2(40),SEGMENT15 VARCHAR2(40),SEGMENT16 VARCHAR2(40),SEGMENT17 VARCHAR2(40),SEGMENT18 VARCHAR2(40),SEGMENT19 VARCHAR2(40),SEGMENT20 VARCHAR2(40),ATTRIBUTE_CATEGORY VARCHAR2(30),ATTRIBUTE1 VARCHAR2(240),ATTRIBUTE2 VARCHAR2(240),ATTRIBUTE3 VARCHAR2(240),ATTRIBUTE4 VARCHAR2(240),ATTRIBUTE5 VARCHAR2(240),ATTRIBUTE6 VARCHAR2(240),ATTRIBUTE7 VARCHAR2(240),ATTRIBUTE8 VARCHAR2(240),ATTRIBUTE9 VARCHAR2(240),ATTRIBUTE10 VARCHAR2(240),ATTRIBUTE11 VARCHAR2(240),ATTRIBUTE12 VARCHAR2(240),ATTRIBUTE13 VARCHAR2(240),ATTRIBUTE14 VARCHAR2(240),ATTRIBUTE15 VARCHAR2(240),PURCHASING_ITEM_FLAG VARCHAR2(1) not null, SHIPPABLE_ITEM_FLAG VARCHAR2(1) not null,CUSTOMER_ORDER_FLAG VARCHAR2(1) not null,INTERNAL_ORDER_FLAG VARCHAR2(1) not null,SERVICE_ITEM_FLAG VARCHAR2(1) not null,INVENTORY_ITEM_FLAG VARCHAR2(1) not null,ENG_ITEM_FLAG VARCHAR2(1) not null,INVENTORY_ASSET_FLAG VARCHAR2(1) not null, PURCHASING_ENABLED_FLAG VARCHAR2(1) not null, CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2(1) not null, INTERNAL_ORDER_ENABLED_FLAG VARCHAR2(1) not null, SO_TRANSACTIONS_FLAG VARCHAR2(1) not null,MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2(1) not null, STOCK_ENABLED_FLAG VARCHAR2(1) not null,BOM_ENABLED_FLAG VARCHAR2(1) not null,BUILD_IN_WIP_FLAG VARCHAR2(1) not null,REVISION_QTY_CONTROL_CODE NUMBER,ITEM_CATALOG_GROUP_ID NUMBER,CATALOG_STATUS_FLAG VARCHAR2(1),RETURNABLE_FLAG VARCHAR2(1),DEFAULT_SHIPPING_ORG NUMBER,COLLATERAL_FLAG VARCHAR2(1),TAXABLE_FLAG VARCHAR2(1),QTY_RCV_EXCEPTION_CODE VARCHAR2(25),ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2(1),INSPECTION_REQUIRED_FLAG VARCHAR2(1), RECEIPT_REQUIRED_FLAG VARCHAR2(1),MARKET_PRICE NUMBER,HAZARD_CLASS_ID NUMBER,RFQ_REQUIRED_FLAG VARCHAR2(1),QTY_RCV_TOLERANCE NUMBER,LIST_PRICE_PER_UNIT NUMBER,UN_NUMBER_ID NUMBER,PRICE_TOLERANCE_PERCENT NUMBER,ASSET_CATEGORY_ID NUMBER,ROUNDING_FACTOR NUMBER,UNIT_OF_ISSUE VARCHAR2(25),ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25), ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1), ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2(1), ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2(1), DAYS_EARLY_RECEIPT_ALLOWED NUMBER,DAYS_LATE_RECEIPT_ALLOWED NUMBER,RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25), RECEIVING_ROUTING_ID NUMBER,INVOICE_CLOSE_TOLERANCE NUMBER,RECEIVE_CLOSE_TOLERANCE NUMBER,AUTO_LOT_ALPHA_PREFIX VARCHAR2(30),START_AUTO_LOT_NUMBER VARCHAR2(30),LOT_CONTROL_CODE NUMBER,SHELF_LIFE_CODE NUMBER,SHELF_LIFE_DAYS NUMBER,SERIAL_NUMBER_CONTROL_CODE NUMBER,START_AUTO_SERIAL_NUMBER VARCHAR2(30), AUTO_SERIAL_ALPHA_PREFIX VARCHAR2(30), SOURCE_TYPE NUMBER,SOURCE_ORGANIZATION_ID NUMBER,SOURCE_SUBINVENTORY VARCHAR2(10),EXPENSE_ACCOUNT NUMBER,ENCUMBRANCE_ACCOUNT NUMBER,RESTRICT_SUBINVENTORIES_CODE NUMBER,UNIT_WEIGHT NUMBER,WEIGHT_UOM_CODE VARCHAR2(3),VOLUME_UOM_CODE VARCHAR2(3),UNIT_VOLUME NUMBER,RESTRICT_LOCATORS_CODE NUMBER,LOCATION_CONTROL_CODE NUMBER,SHRINKAGE_RATE NUMBER,ACCEPTABLE_EARLY_DAYS NUMBER,PLANNING_TIME_FENCE_CODE NUMBER,DEMAND_TIME_FENCE_CODE NUMBER,LEAD_TIME_LOT_SIZE NUMBER,STD_LOT_SIZE NUMBER,CUM_MANUFACTURING_LEAD_TIME NUMBER, OVERRUN_PERCENTAGE NUMBER,MRP_CALCULATE_ATP_FLAG VARCHAR2(1), ACCEPTABLE_RATE_INCREASE NUMBER, ACCEPTABLE_RATE_DECREASE NUMBER, CUMULATIVE_TOTAL_LEAD_TIME NUMBER, PLANNING_TIME_FENCE_DAYS NUMBER,DEMAND_TIME_FENCE_DAYS NUMBER,END_ASSEMBLY_PEGGING_FLAG VARCHAR2(1), REPETITIVE_PLANNING_FLAG VARCHAR2(1), PLANNING_EXCEPTION_SET VARCHAR2(10),BOM_ITEM_TYPE NUMBER not null,PICK_COMPONENTS_FLAG VARCHAR2(1) not null, REPLENISH_TO_ORDER_FLAG VARCHAR2(1) not null, BASE_ITEM_ID NUMBER,ATP_COMPONENTS_FLAG VARCHAR2(1) not null,ATP_FLAG VARCHAR2(1) not null,FIXED_LEAD_TIME NUMBER,VARIABLE_LEAD_TIME NUMBER,WIP_SUPPLY_LOCATOR_ID NUMBER,WIP_SUPPLY_TYPE NUMBER,WIP_SUPPLY_SUBINVENTORY VARCHAR2(10),PRIMARY_UOM_CODE VARCHAR2(3),PRIMARY_UNIT_OF_MEASURE VARCHAR2(25), ALLOWED_UNITS_LOOKUP_CODE NUMBER,COST_OF_SALES_ACCOUNT NUMBER,SALES_ACCOUNT NUMBER,DEFAULT_INCLUDE_IN_ROLLUP_FLAG VARCHAR2(1), INVENTORY_ITEM_STATUS_CODE VARCHAR2(10) not null, INVENTORY_PLANNING_CODE NUMBER,PLANNER_CODE VARCHAR2(10),PLANNING_MAKE_BUY_CODE NUMBER,FIXED_LOT_MULTIPLIER NUMBER,ROUNDING_CONTROL_TYPE NUMBER,CARRYING_COST NUMBER,POSTPROCESSING_LEAD_TIME NUMBER, PREPROCESSING_LEAD_TIME NUMBER,FULL_LEAD_TIME NUMBER,ORDER_COST NUMBER,MRP_SAFETY_STOCK_PERCENT NUMBER,MRP_SAFETY_STOCK_CODE NUMBER,MIN_MINMAX_QUANTITY NUMBER,MAX_MINMAX_QUANTITY NUMBER,MINIMUM_ORDER_QUANTITY NUMBER,FIXED_ORDER_QUANTITY NUMBER,FIXED_DAYS_SUPPLY NUMBER,MAXIMUM_ORDER_QUANTITY NUMBER,ATP_RULE_ID NUMBER,PICKING_RULE_ID NUMBER,RESERVABLE_TYPE NUMBER,POSITIVE_MEASUREMENT_ERROR NUMBER,NEGATIVE_MEASUREMENT_ERROR NUMBER, ENGINEERING_ECN_CODE VARCHAR2(50),ENGINEERING_ITEM_ID NUMBER,ENGINEERING_DATE DATE,SERVICE_STARTING_DELAY NUMBER,VENDOR_WARRANTY_FLAG VARCHAR2(1) not null, SERVICEABLE_COMPONENT_FLAG VARCHAR2(1), SERVICEABLE_PRODUCT_FLAG VARCHAR2(1) not null,BASE_WARRANTY_SERVICE_ID NUMBER,PAYMENT_TERMS_ID NUMBER,PREVENTIVE_MAINTENANCE_FLAG VARCHAR2(1), PRIMARY_SPECIALIST_ID NUMBER,SECONDARY_SPECIALIST_ID NUMBER,SERVICEABLE_ITEM_CLASS_ID NUMBER,TIME_BILLABLE_FLAG VARCHAR2(1),MATERIAL_BILLABLE_FLAG VARCHAR2(30),EXPENSE_BILLABLE_FLAG VARCHAR2(1),PRORATE_SERVICE_FLAG VARCHAR2(1),COVERAGE_SCHEDULE_ID NUMBER,SERVICE_DURATION_PERIOD_CODE VARCHAR2(10), SERVICE_DURATION NUMBER,WARRANTY_VENDOR_ID NUMBER,MAX_WARRANTY_AMOUNT NUMBER,RESPONSE_TIME_PERIOD_CODE VARCHAR2(30), RESPONSE_TIME_VALUE NUMBER,NEW_REVISION_CODE VARCHAR2(30),INVOICEABLE_ITEM_FLAG VARCHAR2(1) not null,TAX_CODE VARCHAR2(50),INVOICE_ENABLED_FLAG VARCHAR2(1) not null,MUST_USE_APPROVED_VENDOR_FLAG VARCHAR2(1) not null, REQUEST_ID NUMBER,PROGRAM_APPLICATION_ID NUMBER,PROGRAM_ID NUMBER,PROGRAM_UPDATE_DATE DATE,OUTSIDE_OPERATION_FLAG VARCHAR2(1) not null, OUTSIDE_OPERATION_UOM_TYPE VARCHAR2(25),SAFETY_STOCK_BUCKET_DAYS NUMBER,AUTO_REDUCE_MPS NUMBER(22),COSTING_ENABLED_FLAG VARCHAR2(1) not null,AUTO_CREATED_CONFIG_FLAG VARCHAR2(1) not null, CYCLE_COUNT_ENABLED_FLAG VARCHAR2(1) not null, ITEM_TYPE VARCHAR2(30),MODEL_CONFIG_CLAUSE_NAME VARCHAR2(10), SHIP_MODEL_COMPLETE_FLAG VARCHAR2(1),MRP_PLANNING_CODE NUMBER,RETURN_INSPECTION_REQUIREMENT NUMBER,ATO_FORECAST_CONTROL NUMBER,RELEASE_TIME_FENCE_CODE NUMBER,RELEASE_TIME_FENCE_DAYS NUMBER,CONTAINER_ITEM_FLAG VARCHAR2(1),VEHICLE_ITEM_FLAG VARCHAR2(1),MAXIMUM_LOAD_WEIGHT NUMBER,MINIMUM_FILL_PERCENT NUMBER,CONTAINER_TYPE_CODE VARCHAR2(30),INTERNAL_VOLUME NUMBER,WH_UPDATE_DATE DATE,PRODUCT_FAMILY_ITEM_ID NUMBER,GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(150), GLOBAL_ATTRIBUTE1 VARCHAR2(150),GLOBAL_ATTRIBUTE2 VARCHAR2(150),GLOBAL_ATTRIBUTE3 VARCHAR2(150),GLOBAL_ATTRIBUTE4 VARCHAR2(150),GLOBAL_ATTRIBUTE5 VARCHAR2(150),GLOBAL_ATTRIBUTE6 VARCHAR2(150),GLOBAL_ATTRIBUTE7 VARCHAR2(150),GLOBAL_ATTRIBUTE8 VARCHAR2(150),GLOBAL_ATTRIBUTE9 VARCHAR2(150),GLOBAL_ATTRIBUTE10 VARCHAR2(150), PURCHASING_TAX_CODE VARCHAR2(50), OVERCOMPLETION_TOLERANCE_TYPE NUMBER, OVERCOMPLETION_TOLERANCE_VALUE NUMBER, EFFECTIVITY_CONTROL NUMBER,CHECK_SHORTAGES_FLAG VARCHAR2(1),OVER_SHIPMENT_TOLERANCE NUMBER,UNDER_SHIPMENT_TOLERANCE NUMBER,OVER_RETURN_TOLERANCE NUMBER,UNDER_RETURN_TOLERANCE NUMBER, EQUIPMENT_TYPE NUMBER,RECOVERED_PART_DISP_CODE VARCHAR2(30), DEFECT_TRACKING_ON_FLAG VARCHAR2(1),USAGE_ITEM_FLAG VARCHAR2(1),EVENT_FLAG VARCHAR2(1),ELECTRONIC_FLAG VARCHAR2(1), DOWNLOADABLE_FLAG VARCHAR2(1),VOL_DISCOUNT_EXEMPT_FLAG VARCHAR2(1),COUPON_EXEMPT_FLAG VARCHAR2(1),COMMS_NL_TRACKABLE_FLAG VARCHAR2(1), ASSET_CREATION_CODE VARCHAR2(30), COMMS_ACTIVATION_REQD_FLAG VARCHAR2(1), ORDERABLE_ON_WEB_FLAG VARCHAR2(1), BACK_ORDERABLE_FLAG VARCHAR2(1),WEB_STATUS VARCHAR2(30),INDIVISIBLE_FLAG VARCHAR2(1),DIMENSION_UOM_CODE VARCHAR2(3),UNIT_LENGTH NUMBER,UNIT_WIDTH NUMBER,UNIT_HEIGHT NUMBER,BULK_PICKED_FLAG VARCHAR2(1),LOT_STATUS_ENABLED VARCHAR2(1),DEFAULT_LOT_STATUS_ID NUMBER,SERIAL_STATUS_ENABLED VARCHAR2(1), DEFAULT_SERIAL_STATUS_ID NUMBER,LOT_SPLIT_ENABLED VARCHAR2(1),LOT_MERGE_ENABLED VARCHAR2(1), INVENTORY_CARRY_PENALTY NUMBER, OPERATION_SLACK_PENALTY NUMBER, FINANCING_ALLOWED_FLAG VARCHAR2(1),EAM_ITEM_TYPE NUMBER,EAM_ACTIVITY_TYPE_CODE VARCHAR2(30),EAM_ACTIVITY_CAUSE_CODE VARCHAR2(30), EAM_ACT_NOTIFICATION_FLAG VARCHAR2(1), EAM_ACT_SHUTDOWN_STATUS VARCHAR2(30), DUAL_UOM_CONTROL NUMBER,SECONDARY_UOM_CODE VARCHAR2(3),DUAL_UOM_DEVIATION_HIGH NUMBER,DUAL_UOM_DEVIATION_LOW NUMBER, CONTRACT_ITEM_TYPE_CODE VARCHAR2(30), SUBSCRIPTION_DEPEND_FLAG VARCHAR2(1), SERV_REQ_ENABLED_CODE VARCHAR2(30), SERV_BILLING_ENABLED_FLAG VARCHAR2(1), SERV_IMPORTANCE_LEVEL NUMBER,PLANNED_INV_POINT_FLAG VARCHAR2(1),LOT_TRANSLATE_ENABLED VARCHAR2(1), DEFAULT_SO_SOURCE_TYPE VARCHAR2(30), CREATE_SUPPLY_FLAG VARCHAR2(1), SUBSTITUTION_WINDOW_CODE NUMBER, SUBSTITUTION_WINDOW_DAYS NUMBER,IB_ITEM_INSTANCE_CLASS VARCHAR2(30), CONFIG_MODEL_TYPE VARCHAR2(30),LOT_SUBSTITUTION_ENABLED VARCHAR2(1), MINIMUM_LICENSE_QUANTITY NUMBER,EAM_ACTIVITY_SOURCE_CODE VARCHAR2(30), LIFECYCLE_ID NUMBER,CURRENT_PHASE_ID NUMBER,OBJECT_VERSION_NUMBER NUMBER(9), TRACKING_QUANTITY_IND VARCHAR2(30), ONT_PRICING_QTY_SOURCE VARCHAR2(30), SECONDARY_DEFAULT_IND VARCHAR2(30), OPTION_SPECIFIC_SOURCED NUMBER, APPROVAL_STATUS VARCHAR2(30),VMI_MINIMUM_UNITS NUMBER,VMI_MINIMUM_DAYS NUMBER,VMI_MAXIMUM_UNITS NUMBER,VMI_MAXIMUM_DAYS NUMBER,VMI_FIXED_ORDER_QUANTITY NUMBER,SO_AUTHORIZATION_FLAG NUMBER, CONSIGNED_FLAG NUMBER,ASN_AUTOEXPIRE_FLAG NUMBER,VMI_FORECAST_TYPE NUMBER,FORECAST_HORIZON NUMBER,EXCLUDE_FROM_BUDGET_FLAG NUMBER, DAYS_TGT_INV_SUPPLY NUMBER,DAYS_TGT_INV_WINDOW NUMBER,DAYS_MAX_INV_SUPPLY NUMBER,DAYS_MAX_INV_WINDOW NUMBER,DRP_PLANNED_FLAG NUMBER,CRITICAL_COMPONENT_FLAG NUMBER, CONTINOUS_TRANSFER NUMBER, CONVERGENCE NUMBER,DIVERGENCE NUMBER,CONFIG_ORGS VARCHAR2(30),CONFIG_MATCH VARCHAR2(30))tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_SYSTEM_ITEMS_B_N1 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, SEGMENT1) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N10 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, PLANNER_CODE) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N11 onINV.MTL_SYSTEM_ITEMS_B (WEB_STATUS, ORGANIZATION_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N12 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID,CUSTOMER_ORDER_ENABLED_FLAG, SERVICE_ITEM_FLAG, VENDOR_WARRANTY_FLAG)tablespace APPS_TS_TX_IDXinitrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N13 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID,WIP_SUPPLY_LOCATOR_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N14 onINV.MTL_SYSTEM_ITEMS_B (BASE_ITEM_ID, ORGANIZATION_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N2 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, DESCRIPTION) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N3 onINV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_STATUS_CODE) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N4 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID,AUTO_CREATED_CONFIG_FLAG)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N5 onINV.MTL_SYSTEM_ITEMS_B (WH_UPDATE_DATE)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N6 onINV.MTL_SYSTEM_ITEMS_B (ITEM_CATALOG_GROUP_ID, CATALOG_STATUS_FLAG)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N7 onINV.MTL_SYSTEM_ITEMS_B (PRODUCT_FAMILY_ITEM_ID, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N8 onINV.MTL_SYSTEM_ITEMS_B (COMMS_NL_TRACKABLE_FLAG, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kmaxextents unlimitedpctincrease 0);create index INV.MTL_SYSTEM_ITEMS_B_N9 onINV.MTL_SYSTEM_ITEMS_B (ORGANIZATION_ID, BUYER_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index INV.MTL_SYSTEM_ITEMS_B_U1 onINV.MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_ID, ORGANIZATION_ID) tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_SYSTEM_ITEMS_B to APPS with grant option;grant select on INV.MTL_SYSTEM_ITEMS_B to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table BOM.CST_COST_TYPES(COST_TYPE_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null, CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER, ORGANIZATION_ID NUMBER,COST_TYPE VARCHAR2(10) not null, DESCRIPTION VARCHAR2(240),COSTING_METHOD_TYPE NUMBER not null, FROZEN_STANDARD_FLAG NUMBER,DEFAULT_COST_TYPE_ID NUMBER not null, BOM_SNAPSHOT_FLAG NUMBER not null, ALTERNATE_BOM_DESIGNATOR VARCHAR2(10), ALLOW_UPDATES_FLAG NUMBER,PL_ELEMENT_FLAG NUMBER not null,PL_RESOURCE_FLAG NUMBER not null,PL_OPERATION_FLAG NUMBER not null,PL_ACTIVITY_FLAG NUMBER not null,DISABLE_DATE DATE,AVAILABLE_TO_ENG_FLAG NUMBER, COMPONENT_YIELD_FLAG NUMBER not null, ATTRIBUTE_CATEGORY VARCHAR2(30), ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),REQUEST_ID NUMBER,PROGRAM_APPLICATION_ID NUMBER,PROGRAM_ID NUMBER,PROGRAM_UPDATE_DATE DATE)tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate unique index BOM.CST_COST_TYPES_U1 on BOM.CST_COST_TYPES (COST_TYPE_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create unique index BOM.CST_COST_TYPES_U2 on BOM.CST_COST_TYPES (COST_TYPE, ORGANIZATION_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onBOM.CST_COST_TYPES to APPS with grant option;grant select on BOM.CST_COST_TYPES to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID NUMBER(15) not null, BUSINESS_GROUP_ID NUMBER(15) not null, COST_ALLOCATION_KEYFLEX_ID NUMBER(9), LOCATION_ID NUMBER(15),SOFT_CODING_KEYFLEX_ID NUMBER(15), DATE_FROM DATE not null,NAME VARCHAR2(240) not null,DATE_TO DATE,INTERNAL_EXTERNAL_FLAG VARCHAR2(30), INTERNAL_ADDRESS_LINE VARCHAR2(80), TYPE VARCHAR2(30),REQUEST_ID NUMBER(15),PROGRAM_APPLICATION_ID NUMBER(15), PROGRAM_ID NUMBER(15),PROGRAM_UPDATE_DATE DATE, ATTRIBUTE_CATEGORY VARCHAR2(30), ATTRIBUTE1 VARCHAR2(150),ATTRIBUTE2 VARCHAR2(150),ATTRIBUTE3 VARCHAR2(150),ATTRIBUTE4 VARCHAR2(150),ATTRIBUTE5 VARCHAR2(150),ATTRIBUTE6 VARCHAR2(150),ATTRIBUTE7 VARCHAR2(150),ATTRIBUTE8 VARCHAR2(150),ATTRIBUTE9 VARCHAR2(150),ATTRIBUTE10 VARCHAR2(150),ATTRIBUTE11 VARCHAR2(150),ATTRIBUTE12 VARCHAR2(150),ATTRIBUTE13 VARCHAR2(150),ATTRIBUTE14 VARCHAR2(150),ATTRIBUTE15 VARCHAR2(150),ATTRIBUTE16 VARCHAR2(150),ATTRIBUTE17 VARCHAR2(150),ATTRIBUTE18 VARCHAR2(150),ATTRIBUTE19 VARCHAR2(150),ATTRIBUTE20 VARCHAR2(150),LAST_UPDATE_DATE DATE,LAST_UPDATED_BY NUMBER(15),LAST_UPDATE_LOGIN NUMBER(15),CREATED_BY NUMBER(15),CREATION_DATE DATE,OBJECT_VERSION_NUMBER NUMBER(9),PARTY_ID NUMBER(15),COMMENTS LONG)tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate primary, unique and foreign key constraints alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_PK primary key (ORGANIZATION_ID)using indextablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kmaxextents unlimitedpctincrease 0);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_UK2 unique (NAME, BUSINESS_GROUP_ID)using indextablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK1 foreign key(BUSINESS_GROUP_ID)references HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID); alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK2 foreign key(COST_ALLOCATION_KEYFLEX_ID)references HR.PAY_COST_ALLOCATION_KEYFLEX(COST_ALLOCATION_KEYFLEX_ID);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK3 foreign key (LOCATION_ID) references HR.HR_LOCATIONS_ALL (LOCATION_ID);alter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_ORGANIZATION_UNITS_FK4 foreign key(SOFT_CODING_KEYFLEX_ID)references HR.HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID);-- Create/Recreate check constraintsalter table HR.HR_ALL_ORGANIZATION_UNITSadd constraint HR_OU_INTERNAL_EXTERNAL_FL_CHKcheck (INTERNAL_EXTERNAL_FLAG IN ('INT', 'EXT'));-- Create/Recreate indexescreate index HR.HR_ORGANIZATION_UNITS_FK1 onHR.HR_ALL_ORGANIZATION_UNITS (BUSINESS_GROUP_ID)tablespace APPS_TS_TX_IDXpctfree 0initrans 11storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK2 onHR.HR_ALL_ORGANIZATION_UNITS (COST_ALLOCATION_KEYFLEX_ID) tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK3 onHR.HR_ALL_ORGANIZATION_UNITS (LOCATION_ID)tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index HR.HR_ORGANIZATION_UNITS_FK4 onHR.HR_ALL_ORGANIZATION_UNITS (SOFT_CODING_KEYFLEX_ID) tablespace APPS_TS_TX_IDXpctfree 0initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onHR.HR_ALL_ORGANIZATION_UNITS to APPS with grant option; grant select on HR.HR_ALL_ORGANIZATION_UNITS to CUX;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_ONHAND_QUANTITIES_DETAIL(INVENTORY_ITEM_ID NUMBER not null,ORGANIZATION_ID NUMBER not null,DATE_RECEIVED DATE,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER,PRIMARY_TRANSACTION_QUANTITY NUMBER not null, SUBINVENTORY_CODE VARCHAR2(10) not null,REVISION VARCHAR2(3),LOCATOR_ID NUMBER,CREATE_TRANSACTION_ID NUMBER,UPDATE_TRANSACTION_ID NUMBER,LOT_NUMBER VARCHAR2(30),ORIG_DATE_RECEIVED DATE,COST_GROUP_ID NUMBER,CONTAINERIZED_FLAG NUMBER,PROJECT_ID NUMBER,TASK_ID NUMBER,ONHAND_QUANTITIES_ID NUMBER not null, ORGANIZATION_TYPE NUMBER not null,OWNING_ORGANIZATION_ID NUMBER not null,OWNING_TP_TYPE NUMBER not null,PLANNING_ORGANIZATION_ID NUMBER not null,PLANNING_TP_TYPE NUMBER not null,TRANSACTION_UOM_CODE VARCHAR2(3) not null, TRANSACTION_QUANTITY NUMBER not null,SECONDARY_UOM_CODE VARCHAR2(3),SECONDARY_TRANSACTION_QUANTITY NUMBER,IS_CONSIGNED NUMBER not null,LPN_ID NUMBER)tablespace APPS_TS_TX_DATApctfree 10initrans 10maxtrans 255storage(initial 128next 128minextents 1maxextents unlimitedpctincrease 0);-- Create/Recreate indexescreate index INV.MTL_ONHAND_QUANTITIES_N4 onINV.MTL_ONHAND_QUANTITIES_DETAIL (INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE,PRIMARY_TRANSACTION_QUANTITY)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_ONHAND_QUANTITIES_N5 onINV.MTL_ONHAND_QUANTITIES_DETAIL (ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, LPN_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);create index INV.MTL_ONHAND_QUANTITIES_N6 onINV.MTL_ONHAND_QUANTITIES_DETAIL (ORGANIZATION_ID, INVENTORY_ITEM_ID, COST_GROUP_ID)tablespace APPS_TS_TX_IDXpctfree 10initrans 11maxtrans 255storage(initial 128Knext 128Kminextents 1maxextents unlimitedpctincrease 0);-- Grant/Revoke object privilegesgrant select, insert, update, delete, references, alter, index onINV.MTL_ONHAND_QUANTITIES_DETAIL to APPS with grant option;下载《Oracle ERP INV 模块8个重要表结构》-- Create tablecreate table INV.MTL_SECONDARY_INVENTORIES(SECONDARY_INVENTORY_NAME VARCHAR2(10) not null, ORGANIZATION_ID NUMBER not null,LAST_UPDATE_DATE DATE not null,LAST_UPDATED_BY NUMBER not null,CREATION_DATE DATE not null,CREATED_BY NUMBER not null,LAST_UPDATE_LOGIN NUMBER,DESCRIPTION VARCHAR2(50),DISABLE_DATE DATE,INVENTORY_ATP_CODE NUMBER not null, AVAILABILITY_TYPE NUMBER not null,RESERVABLE_TYPE NUMBER not null,LOCATOR_TYPE NUMBER,PICKING_ORDER NUMBER,MATERIAL_ACCOUNT NUMBER,MATERIAL_OVERHEAD_ACCOUNT NUMBER, RESOURCE_ACCOUNT NUMBER,OVERHEAD_ACCOUNT NUMBER,OUTSIDE_PROCESSING_ACCOUNT NUMBER, QUANTITY_TRACKED NUMBER not null,。