4.提供一个条形码，查询条形码的存放位置，存放位置的变更及变更时间。

# 4.提供一个条形码，查询条形码的存放位置，存放位置的变更及变更时间。
# 获取条码当前仓库仓位
# 1. 从条码索引表中，查询实际的表名
SELECT FExpendTableName FROM t_lab_labelindex WHERE FBarcode = 'CS07011.02.001.0012002';
# 2. 修改 t_lab_pc_BD_MATERIAL 为 上个查询的结果
SELECT t1.FBarcode          AS 条码,
       t2.FSTOCKIDNUMBER    AS 仓库代码,
       t2.FSTOCKIDNAME      AS 仓库名称,
       t2.FSTOCKLOCIDNUMBER AS 仓位代码,
       t2.FSTOCKLOCIDNAME   AS 仓位名称
FROM t_lab_labelindex t1
         INNER JOIN t_lab_pc_BD_MATERIAL t2 ON t1.FRowId = t2.FROWID
WHERE t1.FBarcode = 'CS07011.02.001.0012002'
;
# 获取条码仓库仓位信息变更情况
SELECT FBarcode          AS 条码,
       FTargetBillName AS 单据类型,
       FTargetBillNumber AS 单据,
       FCommitTime       AS 提交时间,
       FOriginalCKNumber AS 仓库代码,
       FOriginalCKName   AS 仓库名称,
       FOriginalCWNumber AS 仓位代码,
       FOriginalCWName   AS 仓位名称
FROM t_commit_log
WHERE FBarcode = 'CS07011.02.001.0012002'
ORDER BY FCommitTime;