Interface的开发是Oracle ERP中重要的组成部分。
INSERT into MTL_SYSTEM_ITEMS_INTERFACE
(SET_PROCESS_ID
,last_update_date
,last_updated_by
,last_update_login
,creation_date
,created_by
,organization_id
,organization_code
,segment1
--- ,item_number --- disabled on 9/11/03 - cannot handle dots
,description
,revision
,REVISION_QTY_CONTROL_CODE ---7/31
,lot_control_code
,auto_lot_alpha_prefix
,start_auto_lot_number
,template_name
,primary_uom_code
,primary_unit_of_measure
,material_sub_elem
,material_cost
,buyer_id
,planner_code
,process_flag
,transaction_type
,cost_of_sales_account
,sales_account
--- ,inspection_required_flag
,shrinkage_rate
,planning_time_fence_code
,planning_time_fence_days
,fixed_lead_time
,postprocessing_lead_time
,full_lead_time
,wip_supply_type
,inventory_item_status_code
,inventory_planning_code
,fixed_lot_multiplier
,mrp_safety_stock_code
,minimum_order_quantity
,maximum_order_quantity
,min_minmax_quantity
,max_minmax_quantity
,fixed_days_supply
,mrp_planning_code
,attribute1
,attribute2
,attribute4 --- 8/25/3
,attribute14
,LIST_PRICE_PER_UNIT
,SOURCE_TYPE
,SOURCE_ORGANIZATION_ID
)
values
(g_SET_PROCESS_ID
,g_Last_Update_Date
,G_User_Id
,G_User_Id
,G_Creation_Date
,G_User_Id
,G_Organization_id
,v_ITEM_rec.organization_code
,v_ITEM_rec.sep_item_number
---- ,v_ITEM_rec.sep_item_number --- disabled on 9/11/03
,NVL(v_ITEM_rec.Description1,g_dflt_item_description)
,g_starting_revision
,C_REVISION_CONTROL_NO --- 9/12 AS PER DONG -- 7/31
,v_lot_control_code -- 8/25/3
,C_Auto_Lot_Alpha_Prefix -- 7/31
,C_Start_Auto_Lot_Number -- 7/31
,v_ITEM_rec.Template_Name
,v_primary_uom_code
,v_primary_unit_of_measure
,v_material_sub_elem
,v_material_cost
,V_Buyer_ID
,V_Planner_Code
,g_Process_Flag
,g_Transaction_Type
,v_new_COGS_ID -- 7/31
,v_new_Sales_ID -- 7/31
--- ,v_ITEM_rec.inspection_required_flag --- DISABLED AS PER NI's note on 7/14
,v_shrinkage_rate
,v_planning_time_fence_code --- always user defined time fence
,nvl(v_ITEM_rec.planning_time_fence_days,0) --- as per Manju/Ni on 7/14 - zero if null
,V_fixed_lead_time --- 8/25/3
,v_postprocessing_lead_time
,v_full_lead_time --- 8/25/3
,v_wip_supply_type
,v_new_inv_item_status_code --- changed 7/29
,v_inventory_planning_code
,v_ITEM_rec.fixed_lot_multiplier
,v_mrp_safety_stock_code
,v_ITEM_rec.minimum_order_quantity
,v_maximum_order_quantity
,v_min_minmax_quantity
,v_max_minmax_quantity --- 8/25
,v_fixed_days_supply
,v_mrp_planning_code
,v_attribute1 --- 7/31
,v_attribute2 --- CHANGED 7/29
,v_attribute4 --- 8/25/3
,v_category_id --- in attribute14 - temporary
,v_list_price_per_unit --- ADDED 7/29
,v_SOURCE_TYPE --- ADDED 7/29
,v_SOURCE_ORGANIZATION_ID --- ADDED 7/29
);