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,
TASK.NMIDTASK,
TASK.NMTASK
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 FMFMEAPROJECT FPROJ ON (FPROJ.CDFMEA = F.CDFMEA AND FPROJ.CDFMEAREVISION = F.CDREVISION)
LEFT JOIN PRTASK TASK ON (TASK.CDTASK = FPROJ.CDPROJECT AND TASK.FGPHASE <> 99)
WHERE
F.FGTYPEFMEA = 4
AND F.IDFMEA LIKE 'FMEA_ID' /* NOTE1 */
AND R.IDREVISION LIKE 'FMEA_REVISION_ID' /* NOTE2 */
|