SPF_WO_MREQ3_VW

(SQL View)
 Index Back

WORKORDER VIEW TO REQ

view to populate the Multi resource based requistions that are approved & sourced and created by the person who has logged in

SELECT DISTINCT(B.BUSINESS_UNIT) , B.REQUESTOR_ID , A.REQ_ID , A.SP_REQ_ID , B.SP_REQ_STATUS , A.LINE_NBR , B.REQUESTOR_ID FROM PS_PV_REQ_LN_XREF A , PS_SPF_REQ_LINE B WHERE A.SP_REQ_ID = B.SP_REQ_ID AND A.SP_LINE_NBR = B.LINE_NBR AND A.SP_BUSINESS_UNIT = B.BUSINESS_UNIT AND (B.SP_REQ_STATUS = 'A' OR B.SP_REQ_STATUS = 'S') AND B.SERVICE_METHOD = 'M' AND B.SP_ORIGIN_TYPE = 'ORG' AND B.SP_NUM_OF_POSITION = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WO_CLIID Character(30) VARCHAR2(30) NOT NULL Requester
3 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
4 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
5 SP_REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Requisition Status for Service Procurement
A=Approved
C=Complete
D=Denied
F=Filled
O=Open
P=Pending
R=On Hold
S=Sourced
X=Canceled
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id