Overview

This command will list the general data of a Process FMEA (PFMEA).

Related tables

TABLE	Description	Primary key (PK)	Connection tables
FMFMEA	FMEA data	CDFMEA CDREVISION	GNREVISION GNGENTYPE ADCOMPANY ADTEAM OBOBJECT
GNREVISION	Revision data	CDREVISION	FMFMEA OBOBJECT
GNGENTYPE	FMEA type data	CDGENTYPE	FMFMEA
ADCOMPANY	Company data (customer/supplier)	CDCOMPANY	FMFMEA
ADTEAM	Team data	CDTEAM	FMFMEA
OBOBJECT	Item data	CDOBJECT CDREVISION	FMFMEA GNREVISION
PMACTIVITY	Process data	CDACTIVITY	FMFMEA

Oracle/Postgres/SQL Server

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 'FMEA_ID' /* NOTE1 */
   AND R.IDREVISION LIKE 'FMEA_REVISION_ID' /* NOTE2 */

Notes

▪1: FMEA ID #;

▪2: FMEA revision ID #.

Fields used on the view screen

fmea-04

#	Field ID	Type	Description
1	IDFMEA	VARCHAR(50)
2	DTELABORATION	DATETIME	FMEA draft date
3	IDREVISION	VARCHAR(50)
4	DTREVISION	DATETIME	FMEA revision date
5	IDGENTYPE	VARCHAR(50)	FMEA type ID #
5	NMGENTYPE	VARCHAR(255)	FMEA type name
6	FGTYPEFMEA	NUMERIC(2)	FMEA object: 1 - Design (DFMEA) 2 – Process (PFMEA) 3 - Asset 4 - Project structure (Schedule) 5 - Object
7	IDYEARMODELPROG	VARCHAR(50)
8	IDSUPPLIER	VARCHAR(50)	Supplier ID #
8	NMSUPPLIER	VARCHAR(255)	Supplier name
9	IDTEAM	VARCHAR(50)	Responsible team ID #
9	NMTEAM	VARCHAR(255)	Responsible team name
10	DSANALYSIS	TEXT
11	DSOBSERVATION	TEXT
12	IDACTIVITY	VARCHAR(50)	Process ID #
12	NMACTIVITY	VARCHAR(255)	Process name
13	IDPROCESSREVISION	VARCHAR(50)
14	IDOBJECT	VARCHAR(50)	Item ID #
14	NMOBJECT	VARCHAR(255)	Item name
15	IDOBJECTREVISION	VARCHAR(50)
16	IDCUSTOMER	VARCHAR(50)	Customer ID #
16	NMCUSTOMER	VARCHAR(255)	Customer name

General Process FMEA data

Overview

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen