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,
FPROC.IDACTIVITY,
FPROC.NMACTIVITY,
FPROCREV.IDREVISION AS IDPROCESSREVISION,
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)
LEFT JOIN PMACTIVITY FPROC ON (FPROC.CDACTIVITY = F.CDPROCESS)
LEFT JOIN GNREVISION FPROCREV ON (FPROCREV.CDREVISION = F.CDPROCESSREVISION)
WHERE
F.FGTYPEFMEA = 2
AND F.IDFMEA LIKE 'ID_FMEA' /* OBS1 */
AND R.IDREVISION LIKE 'ID_FMEA_REVISION' /* OBS2 */
|
