INV模块的表说明
1. 表关系
1. 物料分类
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 mcs.CATEGORY_SET_NAME = '库存'
AND Mic.Category_Id = Mc.Category_Id
AND Mic.Category_Set_Id = Mcs.Category_Set_Id
AND Mic.Organization_Id = 82 /*l.organization_id*/
AND Mic.Inventory_Item_Id = 1;
/*l.item_id*/