mtl_item_categories

[sudharshan]

can some one give me the link to mtl_system_items and mtl_categories .

Any link for inventory tables joins

regards

sudharshan

[ramakrishna@erpstuff]

I hope following query will help.

SELECT b.concatenated_segments, c.category_set_name
, b.segment1
, b.segment2
FROM apps.mtl_item_categories a
, apps.mtl_categories_kfv b
, apps.mtl_category_sets_vl c
, apps.mtl_system_items_vl d
WHERE a.category_id = b.category_id
AND a.category_set_id = c.category_set_id
--AND c.category_set_name = p_category_set_name
AND a.inventory_item_id =d.inventory_item_id
AND a.organization_id = d.organization_id