Overview

The view displays the APQP type data.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
PAAPQPTYPE	APQP/PPAP type data	CDAPQPTYPE	GNGENTYPE DCCATEGORY
GNGENTYPE	APQP/PPAP type data	CDREVISION	PAAPQPTYPE GNMASK GNREVCONFIG
GNMASK	Identification mask data	CDMASK	GNGENTYPE
DCCATEGORY	Document category data	CDCATEGORY	PAAPQPTYPE
GNREVCONFIG	Revision configurations	CDREVCONFIG	GNGENTYPE

Oracle/Postgres/SQL Server

SELECT
   GNTY.IDGENTYPE,
   GNTY.NMGENTYPE,
   GNTYOWNER.IDGENTYPE AS IDGENTYPEOWNER,
   GNTYOWNER.NMGENTYPE AS NMGENTYPEOWNER,
   GNMASK.IDMASK,
   GNMASK.NMMASK,
   GNTY.FGEDITID,
   DCCAT.IDCATEGORY,
   DCCAT.NMCATEGORY,
   REVCONF.FGUSEREVISION,
   REVCONF.FGTYPEREVISION
FROM
   PAAPQPTYPE PATY
   INNER JOIN GNGENTYPE GNTY ON (PATY.CDAPQPTYPE = Gnty.Cdgentype)
   LEFT JOIN GNGENTYPE GNTYOWNER ON (GNTYOWNER.CDGENTYPE = Gnty.Cdgentypeowner)
   LEFT JOIN GNMASK GNMASK ON (GNMASK.CDMASK = GNTY.CDMASK)
   LEFT JOIN DCCATEGORY DCCAT ON (DCCAT.CDCATEGORY = PATY.CDCATEGORY)
   LEFT JOIN GNREVCONFIG REVCONF ON (REVCONF.CDREVCONFIG = GNTY.CDREVCONFIG)
WHERE
   GNTY.IDGENTYPE LIKE 'TYPE_ID' /* NOTE1 */

Notes

▪NOTE1: APQP/PPAP type ID #

Fields used on the view screen

apqp-02

apqp-03

#	Field ID	Type	Description
1	IDGENTYPE	VARCHAR(50)	APQP/PPAP type ID #
2	NMGENTYPE	VARCHAR(255)	APQP/PPAP type name
3	IDGENTYPEOWNER	VARCHAR(50)	Upper APQP/PPAP type ID #
3	NMGENTYPEOWNER	VARCHAR(255)	Upper APQP/PPAP type name
4	IDMASK	VARCHAR(50)	Identification mask ID #
4	NMMASK	VARCHAR(255)	Identification mask name
5	FGEDITID	NUMERIC(2)	Enable ID # change: 1 - Yes 2 - No
6	IDCATEGORY	VARCHAR(50)	Document category ID #
6	NMCATEGORY	VARCHAR(255)	Document category name
7	FGUSEREVISION	NUMERIC(2)	Control revision: 1 - Yes 2 - No
8	FGTYPEREVISION	NUMERIC(2)	Revision type: 1 - ISO9000 based 2 - Revision via workflow 4 - Simplified