| | |
|---|
| | | Integer getStockStatisCount(Map<String, Object> map); |
|---|
| | | |
|---|
| | | List<LocDetl> getStockStatisExcel(); |
|---|
| | | |
|---|
| | | @Select("select sum(a.anfme) as sum from asr_loc_detl a left join asr_loc_mast b on a.loc_no = b.loc_no where b.loc_sts = 'F' and a.matnr = #{matnr}") |
|---|
| | | Double selectSumAnfmeByMatnr(@Param("matnr") String matnr); |
|---|
| | | |
|---|
| | | List<LocDetl> selectPakoutByRule(String matnr); |
|---|
| | | |
|---|
| | | List<LocDetl> getAsrsLocDetl(String matnr); |
|---|
| | | |
|---|
| | | Integer countLocNoNum(String locNo); |
|---|
| | | |
|---|
| | | // ------------------------------------------------- |
|---|
| | | |
|---|
| | | List<LocDetl> queryStock(@Param("matnr")String matnr, @Param("batch")String batch, @Param("orderNo")String orderNo); |
|---|
| | | |
|---|
| | | } |
|---|
