PMN_PRCSLISTLNG (SQL View)	Index Back
Process Monitor Process List This view is used to list all the process requests in the Process Monitor.

PMN_PRCSLISTLNG

(SQL View)

Process Monitor Process List

This view is used to list all the process requests in the Process Monitor.

SELECT R.PRCSINSTANCE , X.LANGUAGE_CD , X.XLATSHORTNAME FROM PSPRCSRQST R , PSOPRDEFN B , PSPRCSPRFL C , PSXLATITEMLANG X WHERE B.OPRID = R.OPRID AND B.PRCSPRFLCLS = C.CLASSID AND R.RUNSTATUS = X.FIELDVALUE AND R.RUNSTATUS <> '2' AND X.FIELDNAME = 'RUNSTATUS'

Related Language Record for PMN_PRCSLIST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	RUNSTATUSDESCR	Character(10)	VARCHAR2(10) NOT NULL	Run Status