SPF_WO_SRWO_VW

(SQL View)
 Index Back

WOFilled Services Information

WO Filled Services Information related view

SELECT S.BUSINESS_UNIT , S.WORK_ORDER_ID , S.SEQNBR , S.ROLE_TYPE , S.PROJ_ROLE , S.START_DATE , S.END_DATE , S.DURATION , S.WO_RATE , S.CURRENCY_CD , S.LOCATION , S.WO_SOURCE_STATUS , B.SRVC_PROVIDER_ID , B.SPF_RATE , B.BID_ID , B.LINE_ROW , S.COMPUNIT FROM PS_SPF_WO_SERVICE1 S , PS_SPF_BID_LN_FILL B WHERE S.BUSINESS_UNIT = B.BUSINESS_UNIT AND S.WORK_ORDER_ID = B.WORK_ORDER_ID AND S.SEQNBR = B.SEQNBR AND NOT EXISTS ( SELECT 'X' FROM PS_SPF_WORDERREC W WHERE B.BUSINESS_UNIT = W.BUSINESS_UNIT AND B.WORK_ORDER_ID = W.MRSC_PARENT_WOID AND B.BID_ID = W.BID_ID AND B.LINE_ROW = W.LINE_ROW)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
3 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
4 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator
5 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
6 START_DATE Date(10) DATE Start Date for Gen Standing PO
7 END_DATE Date(10) DATE End Date
8 DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration
9 WO_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL WorkOrder Rate
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
12 WO_SOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Work Order Sourcing Status
C=Closed
F=Filled
I=Sourcing Initiated
N=New
R=Ready for Sourcing
S=Sourced
X=Cancel
13 SRVC_PROVIDER_ID Character(15) VARCHAR2(15) NOT NULL Service Provider
14 SPF_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate
15 BID_ID Number(10,0) DECIMAL(10) NOT NULL Bid Id
16 LINE_ROW Number(5,0) INTEGER NOT NULL Line Row
17 COMPUNIT Character(3) VARCHAR2(3) NOT NULL Unit of Measure