PC_BUSPRCACT_VW

(SQL View)
Index Back

BUS Proc Activity Vw


SELECT OBJNAME ,COMPNAME FROM PSBUSPROCITEM A , PSACTIVITYDEFN B WHERE A.COMPNAME = B.ACTIVITYNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
2 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).