Translate

Wednesday, January 9, 2013

ITEM CATEGORIES

ITEM CATEGORIES A category is a logical classification of items that have similar characteristics. A category set is a distinct grouping of categories. Categories and category sets group your items for various reports and programs.If u have more than one Item Category Flexfield Structure, then choose one structure first. (Category KFF structure explained later). Then enter category name and description.A category is visible in iSupplier or iProcurement Portal, if enabled here.


Item Category sets The categories you assign to a category set must have the same flexfield structure as the set itself. This is true even if you choose not to validate the category list.You can assign an item to multiple categories within a category set. For example, you may define a Hazard category set. In this case, an item may be assigned to both the Poison and Corrosive categories.


Default category sets You must assign a default category set to each of these functional areas.When you enable an item for a certain functional area, Oracle Inventory automatically assigns the item to the default category set of that functional area and the default category of that set.For example, if you set Inventory Item to Yes, then Inventory automatically assigns the item to the Inventory functional area’s default category set and default category.

Query to find default category for a category set :
set pages 150
set lines 150

col item form a24
col item_desc form a60
col cat_desc form a40
col default_category form a30
col category_set_name form a30
select
mcats.category_set_name,
mcat.segment1 default_category,
mcat.description cat_desc,
mcat.category_id,
mcats.category_set_id
from
  mtl_category_sets mcats,
  mtl_categories mcat
where mcats.category_set_name like '%'
 and mcat.category_id = mcats.default_category_id
order by 1,2
/




In the Master Items screen assign Category to an Item.
MTL_ITEM_CATEGORIES    

INVENTORY_ITEM_ID     
ORGANIZATION_ID       
CATEGORY_SET_ID       
CATEGORY_ID           
Query to find all items assigned to categories of a category set :
set pages 150
set lines 150

col item form a24
col item_desc form a60
col category form a30
col category_set_name form a24
select
mcats.category_set_name,
mcat.segment1||'.'|| mcat.segment2 category,
msi.segment1 item,
msi.description item_desc
from
  mtl_item_categories  micat,
  mtl_category_sets mcats,
  mtl_categories mcat,
  mtl_system_items_vl  msi
where mcats.category_set_name like 'Inv%'
 and micat.category_set_id = mcats.category_set_id
 and micat.category_id = mcat.category_id
 and mcat.segment1 like 'N%'
 and msi.inventory_item_id = micat.inventory_item_id
 and msi.organization_id =  micat.organization_id
 and msi.organization_id =  204
order by 1,2,3
/




Category KFF


Item Categories KFF has many structures as shown here.Seeded Item Categories structure has 2 segments, Family and Class. Family has an independent validation type value set but Class has dependent validation type value set.

No comments:

Post a Comment