INV常用说明

常用说明"/>

INV常用说明

INV模块的表说明

1. 表关系

1. 物料分类

SELECT Mc.Description,Mc.*FROM Apps.Mtl_Categories      Mc,Apps.Mtl_Category_Sets   Mcs--,Apps.Mtl_Item_Categories MicWHERE /*Mc.Segment1 = 'CP201403120001'AND Mcs.Category_Set_Name = '采购分类'AND*/ Nvl(Mc.Disable_Date, SYSDATE + 1) > SYSDATEAND mcs.CATEGORY_SET_NAME = '库存'AND Mic.Category_Id = Mc.Category_IdAND Mic.Category_Set_Id = Mcs.Category_Set_IdAND Mic.Organization_Id = 82 /*lanization_id*/AND Mic.Inventory_Item_Id = 1; /*l.item_id*/

2. 表说明