SPF_WO_REQ1_VW

(SQL View)
Index Back

WORKORDER DYNAMIC VIEW TO REQ

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

SELECT DISTINCT(B.BUSINESS_UNIT) , A.REQ_ID , O.OPRID , A.SP_REQ_ID , B.SP_REQ_STATUS , B.LINE_NBR FROM PS_PV_REQ_LN_XREF A , PS_SPF_REQ_LINE B ,PSOPRALIAS O 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.SP_NUM_OF_POSITION = 1 AND B.REQUESTOR_ID = O.OPRID

# 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
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]