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*/