• Home   /  
  • Archive by category "1"

Item Category Assignment Open Interface Standards

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
);

收藏分享

 

NRB Bearings Ltd. Item Import thru Interface Ver. 1.0.0Prepared by: Habeeb Ali Shah, Hyd-IT Page 3 of 8Date: 10-OCT-10

Sample data in both tables shown:

MTL_SYSTEM_ITEMS_INTERFACE

selectPROCESS_FLAG,TRANSACTION_TYPE,SET_PROCESS_ID,ORGANIZATION_ID,ITEM_NUMBER,DESCRIPTION,PRIMARY_UOM_CODE,TEMPLATE_NAME,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE15fromMTL_SYSTEM_ITEMS_INTERFACEorderbyITEM_NUMBER,ORGANIZATION_ID

MTL_ITEM_CATEGORIES_INTERFACE

selectPROCESS_FLAG,TRANSACTION_TYPE,SET_PROCESS_ID,ORGANIZATION_ID,ITEM_NUMBER,CATEGORY_SET_NAME,CATEGORY_NAMEfromMTL_ITEM_CATEGORIES_INTERFACEorderbyITEM_NUMBER,ORGANIZATION_ID

Note: Both types of Categories are being assigned simultaneously during new Item Creation

Starting the ‘Item Import Process’

for Creation:

Very Important: Use ‘Change Organization’ function to make ‘Item Master’ as your currentorganization before running the ‘

Import Items

’ as the request

runs defaulting the current organizationRun the IOI process. Navigate --> Inventory: Items: Import ItemsThere are 6 parameters to enter to begin the process:1. Specify one or all organizations.

{ We will select ‘No’ here }

2. Validate items, yes or no. { Alw

ays ‘Yes’}

3. Process items, yes or no.

{ Always ‘Yes’}

4. Delete processed rows, yes or no.

{ ‘No’ for Item Master and ‘Yes’ for select org}

5. Process set (null for all)

{‘123’}

6. Create or update items { 1 for create, 2 for update }Populating set_process_id is mandatory for categories import

One thought on “Item Category Assignment Open Interface Standards

Leave a comment

L'indirizzo email non verrà pubblicato. I campi obbligatori sono contrassegnati *