Navigation: PDM >

List of lower levels in an item family

Overview

This command will display the list of lower levels in an item family.

Related tables

TABLE

Description

Primary key (PK)

Connection tables

OBOBJECT

Item/Asset/Supply data based on revision

CDOBJECT, CDREVISION

OBINPUT

ITITEM

Item record

CDITEM

CDREVISION

OBOBJECT

Oracle/Postgres/SQL Server

SELECT
   OBJ.IDOBJECT,
   OBJ.NMOBJECT
FROM
   OBOBJECT OBJ
  INNER JOIN ITITEM IT ON (OBJ.CDOBJECT = IT.CDITEM AND OBJ.CDREVISION = IT.CDREVISION)
WHERE
   OBJ.CDTEMPLATE IN (
   SELECT
   OBJ.CDOBJECT
   FROM
   OBOBJECT OBJ
   INNER JOIN ITITEM IT ON (OBJ.CDOBJECT = IT.CDITEM AND OBJ.CDREVISION = IT.CDREVISION)
   WHERE
   OBJ.IDOBJECT = 'ITEM ID' /* NOTE1 */
   )

Notes

▪1: Item family ID #.

Fields used on the view screen

pdm-03

#	Field ID	Type	Description
1	IDOBJECT	VARCHAR(50)	Item ID #
2	NMOBJECT	VARCHAR(255)	Item name