每次都想得太複雜,串了一堆,
其實只要匠就可以了........
UPDATE MTL_PHYSICAL_INVENTORY_TAGS A
SET A.TAG_QUANTITY = (SELECT B.SYSTEM_QUANTITY FROM MTL_PHYSICAL_ADJUSTMENTS_VIEW B WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID(+) AND B.ORGAZIRATION = :PARAMETER.ORG_ID AND B.PHYSICAL_INVENTORY_ID = 1591 )
WHERE A.ORGAZIRATION = :PARAMETER.ORG_ID AND A.PHYSICAL_INVENTORY_ID = 1591
請先 登入 以發表留言。