产品Code查询

1.设定线体

2.查找Creation工位

select id_modeop from t_modeop m
INNER JOIN t_action a ON m.id_modeop = a.et_modeop
where m.et_prod_poste LIKE '6001%'
AND m.modeop_ordre_plc = 1
AND m.et_tyoper = 'OPE'
AND a.et_tyact = 1;