Overview

This command will list the main data referring to the approval route of a plan/action.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
GNACTIVITY	Table that stores common activity information (it is also used by other components, such as Workflow, Survey, Asset, etc.)	CDGENACTIVITY	GNAPPROV
GNAPPROV	Table that stores the specific approval data of each record	CDPROD CDAPPROV	GNACTIVITY ADAPPROVALROUTE GNAPPROVRESP
ADAPPROVALROUTE	Table that stores approval routes	CDAPPROVALROUTE	GNAPPROV ADAPPROVROUTERESP

Oracle/Postgres/SQL Server

SELECT GNACTIVITY.CDGENACTIVITY, /*NOTE1*/
GNACTIVITY.IDACTIVITY,
GNACTIVITY.NMACTIVITY,
ROUTEPLANEJ.IDAPPROVALROUTE AS IDAPPROVALROUTE_PLANEJ,
ROUTEPLANEJ.NMAPPROVALROUTE AS NMAPPROVALROUTE_PLANEJ,
APPROVPLANEJ.FGINCREMENTAL AS FGINCREMENTAL_PLANEJ,
APPROVPLANEJ.NRLASTCYCLE AS NRLASTCYCLE_PLANEJ,
APPROVPLANEJ.FGALLMEMBERAPPROV AS FGALLMEMBERAPPROV_PLANEJ,
ROUTEEXEC.IDAPPROVALROUTE AS IDAPPROVALROUTE_EXEC,
ROUTEEXEC.NMAPPROVALROUTE AS NMAPPROVALROUTE_EXEC,
APPROVEXEC.FGINCREMENTAL AS FGINCREMENTAL_EXEC,
APPROVEXEC.NRLASTCYCLE AS NRLASTCYCLE_EXEC,
APPROVEXEC.FGALLMEMBERAPPROV AS FGALLMEMBERAPPROV_EXEC
FROM GNACTIVITY
LEFT OUTER JOIN GNAPPROV APPROVPLANEJ ON APPROVPLANEJ.CDPROD = GNACTIVITY.CDPLANPRODROUTE AND APPROVPLANEJ.CDAPPROV = GNACTIVITY.CDPLANROUTE
LEFT OUTER JOIN GNAPPROV APPROVEXEC ON APPROVEXEC.CDPROD = GNACTIVITY.CDPRODROUTE AND APPROVEXEC.CDAPPROV = GNACTIVITY.CDEXECROUTE
LEFT OUTER JOIN ADAPPROVALROUTE ROUTEPLANEJ ON ROUTEPLANEJ.CDAPPROVALROUTE = APPROVPLANEJ.CDAPPROVALROUTE
LEFT OUTER JOIN ADAPPROVALROUTE ROUTEEXEC ON ROUTEEXEC.CDAPPROVALROUTE = APPROVEXEC.CDAPPROVALROUTE
WHERE GNACTIVITY.CDISOSYSTEM = 174
AND GNACTIVITY.IDACTIVITY = 'Action_or_plan_ID'; /*NOTE2*/

Notes

▪1: Unique internal code of the record (action or plan);

▪2: Record ID # (action or plan).

Fields used on the view screen

action_plan-04