PV_MOBL_LIST

(SQL View)

SELECT DISTINCT C.BUSINESS_UNIT ,C.REQ_ID ,C.INSTANCEID ,A.OPRID FROM PSWORKLIST A ,PSEVENTROUTE B ,PS_PV_REQ_APPR_WL C , PS_REQ_HDR D WHERE A.INSTSTATUS < 2 AND A.ACTIVITYNAME = B.ACTIVITYNAME AND A.EVENTNAME = B.EVENTNAME AND A.WORKLISTNAME = B.ROUTENAME AND B.WLRECNAME = 'PV_REQ_APPR_WL' AND A.BUSPROCNAME = C.BUSPROCNAME AND A.ACTIVITYNAME = C.ACTIVITYNAME AND A.EVENTNAME = C.EVENTNAME AND A.WORKLISTNAME = C.WORKLISTNAME AND A.INSTANCEID = C.INSTANCEID AND A.TRANSACTIONID = C.TRANSACTIONID AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.REQ_ID = D.REQ_ID AND D.REQ_STATUS = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

3 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
3	INSTANCEID	Number(10,0)	DECIMAL(10) NOT NULL	For a given worklist the unique number of rows in PSWORKLIST
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).