ebs物料归类sql

SELECT mc.description
      ,mc.*
FROM   apps.mtl_categories      mc
      ,apps.mtl_category_sets   mcs
      ,apps.mtl_item_categories mic
WHERE  mc.segment1 = 'CP201403120001'
AND    mcs.category_set_name = '采购分类'
AND    nvl(mc.disable_date, SYSDATE + 1) > SYSDATE
AND    mic.category_id = mc.category_id
AND    mic.category_set_id = mcs.category_set_id
AND    mic.organization_id = 126 /*l.organization_id*/
AND    mic.inventory_item_id = 281 /*l.item_id*/