Page 1 of 1
mtl_item_categories
Posted: Thu Sep 11, 2008 8:15 am
by sudharshan
can some one give me the link to mtl_system_items and mtl_categories .
Any link for inventory tables joins
regards
sudharshan
Posted: Fri Sep 19, 2008 5:59 pm
by 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