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 NameField TypeColumn TypeDescription
    RECURNAMECharacter(30)VARCHAR2(30) NOT NULLRecurrence Name
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    RUNSTATUSDESCRCharacter(10)VARCHAR2(10) NOT NULLRun Status
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19