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 NameField TypeColumn TypeDescription
    PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    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