保存参数查询

按批次250501SA001查661360700C件号ST20 RECEIVE CRIMPING DATA

 

select '661360700C' as Part_number, et_stocpf,cartra_valeur,t_carath.et_unite,t_carath.carath_libelle,t_cartra.datemodif,t_cartra.heuremodif from t_cartra,t_carath

where et_stocpf in(select ID_STOCPF  from t_stocpf where ET_LOTPF='250501SA001')

and t_cartra.et_carath=t_carath.id_carath and carath_libelle='ST20 RECEIVE CRIMPING DATA'