产品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;

3.最终完整的查询为

SELECT DISTINCT t1.et_refcmp,cliref_valeur
FROM t_cliref t1
JOIN t_nomen t2 ON t1.et_refcmp = t2.et_refakf_se
JOIN t_simo t3 ON t2.id_nomen = t3.et_nomen
JOIN t_modeop m ON t3.et_modeop = m.id_modeop
JOIN t_action a ON m.id_modeop = a.et_modeop
WHERE t1.et_carcli = 7
and t2.nomen_fin_validite is null
AND t2.et_typtra = 'U'
AND m.et_prod_poste LIKE '8023%'
AND m.modeop_ordre_plc = 1
AND m.et_tyoper = 'OPE'
AND a.et_tyact = 1
order by t1.et_refcmp