AR_AE_PROCS_LVW (SQL View)	Index Back
AR Reset Process List This view is used to list all the process requests in the AR Resetr. It will only list Application Engine starting with 'AR' and has status of '3' (error) and '10' (not success).

AR_AE_PROCS_LVW

(SQL View)

AR Reset Process List

This view is used to list all the process requests in the AR Resetr. It will only list Application Engine starting with 'AR' and has status of '3' (error) and '10' (not success).

SELECT P.PRCSNAME , P.LANGUAGE_CD , P.DESCR FROM PS_PRCSDEFN P1 , PS_PRCSDEFNLANG P WHERE P1.PRCSNAME = P.PRCSNAME AND P1.PRCSTYPE = 'Application Engine' AND %Substring(P1.PRCSNAME, 1, 2) = 'AR'

Related Language Record for AR_AE_PROCS_VW RTM_AE_PRCS_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

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

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description