2014年2月23日 星期日

Oracle ASCP Z_ItemOperation



SELECT * FROM adempiere.Z_ItemOperation

SELECT i.Name Item, o.Name Operation, r.Name AS Resource, u.Name UOM,
Usage, Min_Transfer_Qty
FROM adempiere.Z_ItemOperation io
inner join adempiere.Z_Resource r ON io.Z_Resource_ID=r.Z_Resource_ID
inner join adempiere.Z_Item i ON io.Z_Item_ID=i.Z_Item_ID
inner join adempiere.Z_Operation o ON io.Z_Operation_ID=o.Z_Operation_ID
inner join adempiere.Z_UOM u ON io.Z_UOM_ID=u.Z_UOM_ID

"9-000-A0";"切削 ";"五號研磨機";"MIN";10.0;99999
"9-000-A0";"切削 ";"五號研磨機";"MIN";10.0;99999
"9-000-A0";"切削 ";"組裝二線";"MIN";1;0

沒有留言:

張貼留言