SELECT
TWC.MANUFACTURE_CODE AS 生产子订单,
RWC.CARTON_CODE AS 托盘号,
TWC.CELL_CODE AS 电芯码,
TWC.OCV3_VOLTAGE AS 电压,
TWC.OCV3_RESISTANCE AS 内阻,
TWC.K_VAL AS K值,
TWC.FOUTH_OUT_CAPACITY AS 容量,
TWC.CELL_GRADE AS 档位
FROM TT_WO_CELL TWC
LEFT JOIN TR_WO_CARTON_CELL RWC ON TWC.CELL_CODE=RWC.CELL_CODE
WHERE CARTON_CODE IN
(SELECT DISTINCT(IN_OBJECT) FROM TT_PRODUCT_APPLY_RECORD WHERE APPLY_ID =(SELECT PK_ID FROM TT_PRODUCT_APPLY WHERE APPLY_LIST = '${控件名称}'));
ORDER BY TWC.MANUFACTURE_CODE DESC,RWC.CARTON_CODE