SELECT
F.IDFMEA,
F.DTELABORATION,
R.IDREVISION,
R.DTREVISION,
TY.IDGENTYPE,
TY.NMGENTYPE,
F.FGTYPEFMEA,
F.IDYEARMODELPROG,
S.IDCOMMERCIAL AS IDSUPPLIER,
S.NMCOMPANY AS NMSUPPLIER,
T.IDTEAM,
T.NMTEAM,
F.DSANALYSIS,
F.DSOBSERVATION,
FASSET.IDOBJECT,
FASSET.NMOBJECT,
FASSETREV.IDREVISION AS IDOBJECTREVISION
FROM FMFMEA F
INNER JOIN GNREVISION R ON (F.CDREVISION = R.CDREVISION)
INNER JOIN GNGENTYPE TY ON (TY.CDGENTYPE = F.CDGENTYPE)
LEFT JOIN ADCOMPANY S ON (S.CDCOMPANY = F.CDSUPPLIER)
LEFT JOIN ADTEAM T ON (T.CDTEAM = F.CDFMEARESP)
LEFT JOIN ASFMEAASSET ASFMEAST ON (F.CDFMEA = ASFMEAST.CDFMEA AND F.CDREVISION = ASFMEAST.CDFMEAREVISION)
LEFT JOIN OBOBJECT FASSET ON (ASFMEAST.CDASSET = FASSET.CDOBJECT AND FASSET.CDREVISION = ASFMEAST.CDASSETREVISION)
LEFT JOIN GNREVISION FASSETREV ON ( FASSET.CDREVISION = FASSETREV.CDREVISION)
WHERE
F.FGTYPEFMEA = 3
AND F.IDFMEA LIKE 'FMEA_ID' /* NOTE1 */
AND R.IDREVISION LIKE 'FMEA_REVISION_ID' /* NOTE2 */
|