RC_WL_BPNAM_VW2

(SQL View)
 Index Back

Business Project View

This view returns Business Project Names for use in worklist configurable search.

SELECT B.RC_BUS_PROCESS_ID , C.DESCR FROM PS_RC_WF_BUSPRC_VW A , PS_RC_BP_STATUS B , PS_RC_BUS_PROCESS C WHERE B.BUS_PROC_INSTANCE = A.BUS_PROC_INSTANCE AND C.RC_BUS_PROCESS_ID = B.RC_BUS_PROCESS_ID AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_RC_BUS_PROCESS D WHERE D.RC_BUS_PROCESS_ID = C.RC_BUS_PROCESS_ID AND D.BUS_PROJ_TYPE = C.BUS_PROJ_TYPE AND D.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.
2 DESCR_BUS_PROCESS Character(30) VARCHAR2(30) NOT NULL This field is used to temporarily store the description of a Business Project.