0RA-00952 on inner join with Oracle 10g
I won't accept my own answer fast. Feel free to submit a more precise one, especially if you found a public bug report from Oracle.
I found a workaround :
SELECT PRODUCT_INFOS.FIELD_VALUE, COIL_INFOS.TIME_STAMP, COIL_INFOS.IN_THICKNESS, COIL_INFOS.MEASURED_LENGTH, COIL_INFOS.MEASURED_WIDTH, COIL_INFOS.PARAM_SET_TOP_SIDE, COIL_INFOS.PARAM_SET_BOTTOM_SIDEFROM COIL_INFOS, PRODUCT_INFOSWHERE PRODUCT_INFOS.COIL_ID_SYSTEM=COIL_INFOS.COIL_ID_SYSTEM and PRODUCT_INFOS.TIME_STAMP=COIL_INFOS.TIME_STAMP and PRODUCT_INFOS.FIELD_NAME='ID bobina' and (COIL_INFOS.COIL_ID_SYSTEM LIKE '14051800' OR COIL_INFOS.COIL_IDLIKE '14051800')
This simplified syntax for the same query does work on the 10g server. I'm more on more on the opinion the used 10g version is buggy.