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,
FITEM.IDOBJECT,
FITEM.NMOBJECT,
FITEMREV.IDREVISION AS IDOBJECTREVISION,
C.IDCOMMERCIAL AS IDCUSTOMER,
C.NMCOMPANY AS NMCUSTOMER
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 OBOBJECT FITEM ON (FITEM.CDOBJECT = F.CDITEM AND FITEM.CDREVISION = F.CDITEMREVISION)
LEFT JOIN GNREVISION FITEMREV ON (FITEMREV.CDREVISION = FITEM.CDREVISION)
LEFT JOIN ADCOMPANY C ON (C.CDCOMPANY = F.CDCUSTOMER)
WHERE
F.FGTYPEFMEA = 1
AND F.IDFMEA LIKE 'FMEA_ID' /* NOTE1 */
AND R.IDREVISION LIKE 'FMEA_REVISION_ID' /* NOTE2 */
|