PMN_PRCSLISTLNG

index back

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 Field Type Column Type Description
    PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19