{"id":1458,"date":"2026-01-10T12:12:02","date_gmt":"2026-01-10T04:12:02","guid":{"rendered":"https:\/\/www.jumoon.top\/?p=1458"},"modified":"2026-01-12T12:13:40","modified_gmt":"2026-01-12T04:13:40","slug":"%e9%bc%8e%e6%8d%b7e10%e6%89%b9%e9%87%8f%e4%bf%ae%e6%94%b9%e5%93%81%e5%8f%b7%e6%9c%80%e5%90%8e%e4%b8%80%e6%ac%a1%e5%85%a5%e5%ba%93%e5%ba%93%e4%bd%8d%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/www.jumoon.top\/?p=1458","title":{"rendered":"\u9f0e\u6377E10\u6279\u91cf\u4fee\u6539\u54c1\u53f7\u6700\u540e\u4e00\u6b21\u5165\u5e93\u5e93\u4f4d\u4fe1\u606f"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>--\u6700\u540e\u4e00\u6b21\u5165\u5e93\u5e93\u4f4d\u5e26\u51fa\u7684\u662f\u5df2\u7ecf\u505c\u7528\u5e93\u4f4d\u7684\u54c1\u53f7\u4fe1\u606f\nselect \ne.PLANT_NAME,b.ITEM_CODE as \u54c1\u53f7,b.ITEM_NAME as \u54c1\u540d,c.WAREHOUSE_CODE as \u4ed3\u5e93\u7f16\u7801,c.WAREHOUSE_NAME as \u4ed3\u5e93\u540d\u79f0,d.BIN_CODE as \u6700\u8fd1\u5165\u5e93\u5e93\u4f4d\u7f16\u7801,d.BIN_NAME as \u6700\u8fd1\u5165\u5e93\u5e93\u4f4d\u540d\u79f0,\na.Owner_Org_ROid,a.ITEM_ID,a.WAREHOUSE_ID,a.BIN_ID from  ITEM_WAREHOUSE a \nleft join  ITEM b on a.ITEM_ID =b.ITEM_BUSINESS_ID\nleft join  WAREHOUSE c on a.WAREHOUSE_ID=c.WAREHOUSE_ID\nLEFT join  BIN d on a.BIN_ID=d.BIN_ID\nleft join  PLANT e on a.Owner_Org_ROid= e.PLANT_ID\nwhere  a.BIN_ID in (select BIN_ID from BIN where ApproveStatus &lt;> 'Y')  --\u67e5\u770bBIN ID\u4e3a\u505c\u7528\u72b6\u6001\u7684\nORDER BY c.WAREHOUSE_CODE,d.BIN_CODE\n\n--\u6839\u636e\u4e0a\u9762\u67e5\u8be2\u7ed3\u679c\u7684 WAREHOUSE_ID+BIN_ID \u67e5\u8be2\u8981\u66ff\u6362\u7684\u6570\u636e\u8303\u56f4\nselect * from ITEM_WAREHOUSE\nwhere BIN_ID ='F52972A6-8261-4937-485A-1C05C37C89E6'\n\n\n--\u67e5\u8be2\u6307\u5b9a\u4ed3\u5e93\uff0c\u5e93\u4f4d\uff0c\u6240\u5728\u5de5\u5382\u7684 BIN_ID\uff0c\u5373\u8981\u7528\u4f5c\u66ff\u6362\u7684\u65b0BIN_ID\nselect c.PLANT_NAME,a.WAREHOUSE_ID,b.BIN_ID,a.WAREHOUSE_CODE,a.WAREHOUSE_NAME,a.BIN_CONTROL,b.BIN_CODE,b.BIN_NAME from WAREHOUSE a \nleft join BIN b on a.WAREHOUSE_ID=b.WAREHOUSE_ID \nleft join PLANT c  on a.Owner_Org_ROid=c.PLANT_ID\nWHERE BIN_CODE = 'F10101' and WAREHOUSE_CODE ='M'\n\n--SELECT * into ITEM_WAREHOUSE20260109 from ITEM_WAREHOUSE   ---\u5907\u4efd\u8868\n\n\n--\u66f4\u65b0\u65b0\u7684BIN_ID\u66ff\u6362\u65e7\u7684BIN_ID(\u6ce8\u610f\u533a\u5206\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u5de5\u5382\uff0c\u76f8\u540c\u5e93\u4f4d\uff0c\u4e0d\u540c\u5de5\u5382\u7684BIN_ID\u503c\u4e0d\u4e00\u6837)\nupdate ITEM_WAREHOUSE set BIN_ID = '776177BD-0976-4E1E-187E-1C020E2C1729' \nwhere BIN_ID ='F52972A6-8261-4937-485A-1C05C37C89E6' <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[19],"tags":[],"class_list":["post-1458","post","type-post","status-publish","format-standard","hentry","category-19"],"_links":{"self":[{"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/posts\/1458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1458"}],"version-history":[{"count":2,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/posts\/1458\/revisions"}],"predecessor-version":[{"id":1460,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/posts\/1458\/revisions\/1460"}],"wp:attachment":[{"href":"https:\/\/www.jumoon.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}