RB_WL_R_SO_VW

(SQL View)
 Index Back

Workflow VW for case reassign

Workflow view for service order reassignment.

SELECT A.OPRID , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , B.BUSINESS_UNIT , B.SO_ID , B.SO_LINE , D.PROVIDER_GRP_ID , D.PERSON_ID , C.BO_ID_CUST , C.ROW_ADDED_DTTM FROM PSWORKLIST A , PS_RF_SERVICE_WL B , PS_RF_SO_HDR C , PS_RF_SOLN_ASSIGN D WHERE A.BUSPROCNAME = B.BUSPROCNAME AND A.ACTIVITYNAME = B.ACTIVITYNAME AND A.EVENTNAME = B.EVENTNAME AND A.WORKLISTNAME = B.WORKLISTNAME AND A.INSTANCEID = B.INSTANCEID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.SO_ID = C.SO_ID AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.SO_ID = D.SO_ID AND D.PRIMARY_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
3 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
4 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
5 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
6 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
9 SO_LINE Number(3,0) SMALLINT NOT NULL Stores the Service Order line number.
10 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
11 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.
12 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.