SPF_SPC_SRWO_VW

(SQL View)
 Index Back

Sourcing Provider contact vw


SELECT A.BUSINESS_UNIT ,B.SP_REQ_ID , B.LINE_NBR ,A.WORK_ORDER_ID ,A.VENDOR_ID ,D.VNDR_LOC , B.SERVICE_METHOD ,D.SUBMIT_TO ,D.SPC_OWNER ,%DatePart(SOURCING_DATE) ,0 ,0 ,VENDOR_SETID ,RECRUITER ,PROJECT_ID , PROJ_ROLE ,D.ROW_CREATE_USER ,1 ,SEQUENCE2 FROM PS_SPF_WO_SOURCING A ,PS_SPF_WORDERREC B ,PS_SPF_WO_SRC_HIST D WHERE A.WORK_ORDER_ID = B.WORK_ORDER_ID AND A.WORK_ORDER_ID = D.WORK_ORDER_ID AND A.SEQNBR =D.SEQNBR AND A.BUSINESS_UNIT =B.BUSINESS_UNIT AND A.BUSINESS_UNIT =B.BUSINESS_UNIT AND A.VENDOR_ID =D.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
7 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource
8 CONTACT Character(15) VARCHAR2(15) NOT NULL Provider Contact
9 SPC_OWNER Character(15) VARCHAR2(15) NOT NULL Owner
10 SOURCE_DATE Date(10) DATE Source Date
11 SUBMITAL_LIMIT Number(2,0) SMALLINT NOT NULL Submittal Limit
12 SUBMITAL_NUMBER Number(4,0) SMALLINT NOT NULL Number of Times Submitted
13 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
14 RECRUITER Character(15) VARCHAR2(15) NOT NULL Service Coordinator
15 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
16 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
17 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
18 SP_NUM_OF_POSITION Number(5,0) INTEGER NOT NULL Number of Positions
19 SEQUENCE2 Number(6,0) INTEGER NOT NULL Sequence