840d68e97dde7037458567a63b28a42aefc5673a.svn-base 829 B

12345678910111213141516171819202122232425
  1. <?xml version="1.0" encoding='UTF-8'?>
  2. <queryMap desc="查询错误订单信息">
  3. <query id="UIB015110_01.INITSELECT" desc="获得错误代码的相信信息 ErrorMessage">
  4. SELECT
  5. SM_CFNM LABEL
  6. ,SM_CD VALUE
  7. FROM TBZ00_COMMCD
  8. WHERE LG_CD = 'B01014'
  9. </query>
  10. <query id="UIB015110_01.SELECT" desc="查询错误订单信息 ErrorOrdResult" fetchSize="10">
  11. <![CDATA[
  12. SELECT
  13. T1.ERR_DTIME --错误时间
  14. , T1.DSG_ERROR_CD --设计错误代码
  15. , T1.DSG_ERROR_CD ERROR_DETAIL --设计错误代码,为显示错误说明而准备
  16. , T1.ORD_NO
  17. , T1.ORD_SEQ --错误订单
  18. FROM TBB01_ERR_ORD T1
  19. WHERE 1 = 1
  20. ]]>
  21. </query>
  22. </queryMap>