ITEM畫面的RECEIVING頁簽的RECEIVING SUBINVENTORY是
存放在TABLE:MTL_ITEM_SUB_DEFAULTS
COL是subinventory_code
在ITEM畫面中修改後,這里也只有最後錄入的.
[@more@]select MISD.INVENTORY_ITEM_ID,MSIB.SEGMENT1,MISD.subinventory_codefrom MTL_ITEM_SUB_DEFAULTS MISD
, MTL_SYSTEM_ITEMS_B MSIB
where MISD.INVENTORY_ITEM_ID=MSIB.INVENTORY_ITEM_ID
AND MISD.organization_id =MSIB.ORGANIZATION_ID
AND MSIB.ORGANIZATION_ID =:ORG_ID
and msib.segment1=:ITEM
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/92289/viewspace-1038965/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/92289/viewspace-1038965/