PMN_RECURLSTLNG

index back

Process Monitor Process List

This view is used to list all the process requests in the Process Monitor.
SELECT R.RECURNAME , 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' AND R.RECURNAME <> ' '

  • Related language record for PMN_RECUR_LIST
  • PeopleSoft Field Name Field Type Column Type Description
    RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name
    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