SPF_WO_RSRC_VW2

(SQL View)
 Index Back

Service Provider List WO View2

Show service provider info for resource based work orders

SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , P.PERSON_ID , A.VENDOR_ID , A. WO_CONID , ' ' , A.DEPTID , A.WO_NAME , A.START_DATE , A.END_DATE , A.WO_STATUS , A.SP_TRACK_RESRC ,'N' , A.ROW_CREATE_DATE ,' ' , A.SERVICE_METHOD , A.MRSC_PARENT_WOID , A.ROLE_TYPE , A.PROJ_ROLE FROM PS_SPF_WORDERREC A , PS_SPB_PERSON_TBL P WHERE A.SERVICE_METHOD = 'R' AND P.PERSON_ID IN ( SELECT WO_CONID FROM PS_SPF_WORDERREC A1 WHERE A1.BUSINESS_UNIT = A.BUSINESS_UNIT AND A1.WORK_ORDER_ID = A.WORK_ORDER_ID AND A.SP_TRACK_RESRC = 'N')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_SP_NONVW

2 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order
6 NAME50 Character(50) VARCHAR2(50) NOT NULL name field of length 50
7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
8 WO_NAME Character(30) VARCHAR2(30) NOT NULL Work Order Name
9 START_DATE Date(10) DATE Start Date for Gen Standing PO
10 END_DATE Date(10) DATE End Date
11 WO_STATUS Character(1) VARCHAR2(1) NOT NULL Work Order Status
A=Approved
C=Closed
D=Denied
F=Finalize
L=Released
N=Canceled
O=Open
P=Pending Terminate
S=Submitted
T=Terminated
12 SP_TRACK_RESRC Character(1) VARCHAR2(1) NOT NULL Track Resource
B=Default From Business Unit
N=No
Y=Yes
13 SP_PREMISE_LOC Character(1) VARCHAR2(1) NOT NULL Premise Location
N=No
Y=Yes
14 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time
15 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments
16 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource
17 MRSC_PARENT_WOID Character(15) VARCHAR2(15) NOT NULL Multi Resource Parent WOID
18 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator
19 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role