Navigation: Process >

Business unit

Overview

This command will list the business unit configured in the process data.

Related tables

Table	Description	Primary key (PK)	Connection tables
PMACTREVISION	Process revision table	PMACTREVISION
PMPROCESSDEPT	Process department table	PKPMPROCESSDEPT
ADDEPARTMENT	Department record table	PKADDEPARTMENT

Oracle/Postgres/SQL Server

SELECT
   AREV.IDACTIVITY AS PROCESS_ID,
   AREV.NMACTIVITY AS PROCESS_NAME,
   D.IDDEPARTMENT,
   D.NMDEPARTMENT
FROM
   PMACTREVISION AREV
   INNER JOIN PMPROCESSDEPT PD ON AREV.CDACTIVITY = PD.CDPROCESS
   INNER JOIN ADDEPARTMENT D ON PD.CDDEPARTMENT = D.CDDEPARTMENT
WHERE
   AREV.IDACTIVITY = 'BPM000001' /*NOTE1*/
   AND AREV.FGCURRENT= 1
ORDER BY D.IDDEPARTMENT, D.NMDEPARTMENT

Notes

▪1: Process ID #.

Fields used on the view screen

processo-01

#	Field ID	Type	Description
1	IDACTIVITY	VARCHAR(50)	Field of the PMACTREVISION table
2	NMACTIVITY	VARCHAR(255)	Field of the PMACTREVISION table
3	IDDEPARTMENT	VARCHAR(50)	Field of the ADDEPARTMENT table
4	NMDEPARTMENT	VARCHAR(255)	Field of the ADDEPARTMENT table