Query to To Check Item Catogry For Inventory master (No Of Segments May Varry) - SQL

Oracle Apps >Oracle SQL

Query to To Check Item Catogry For Inventory master (No Of Segments May Varry) - SQL

Following is the query:

SELECT ood.organization_name,
segment1|| ‘-’|| segment2|| ‘-’|| segment3 catgory
FROM org_organization_definitions ood,
mtl_categories_vl mcv,
mtl_category_sets mcs
WHERE mcs.structure_id = mcv.structure_id
ORDER BY ood.organization_name