SPF_SPC_SR_VW

(SQL View)
 Index Back

Sourcing Provider contact vw

/* 1525318000 - Add condition to only include Closed, Filled or Sourced requisitions */

SELECT C.SP_BUSINESS_UNIT ,C.SP_REQ_ID , C.SP_LINE_NBR , B.SP_REQ_STATUS , C.BUSINESS_UNIT , C.REQ_ID , C.LINE_NBR , A.VENDOR_ID ,D.VNDR_LOC ,D.SUBMIT_TO ,D.SPC_OWNER ,%DatePart(SOURCING_DATE) ,SUBMITAL_LIMIT ,SUBMITAL_NUMBER ,VENDOR_SETID ,RECRUITER ,PROJECT_ID , PROJ_ROLE ,D.ROW_CREATE_USER ,B.SP_NUM_OF_POSITION ,B.SERVICE_METHOD ,SEQUENCE2 FROM PS_SPF_SOURCING A ,PS_SPF_REQ_LINE B , PS_PV_REQ_LN_XREF C ,PS_SPF_SOURCE_HIST D WHERE A.SP_REQ_ID = B.SP_REQ_ID AND A.LINE_NBR =B.LINE_NBR AND A.BUSINESS_UNIT =B.BUSINESS_UNIT AND B.SP_REQ_ID = C.SP_REQ_ID AND B.LINE_NBR =C.SP_LINE_NBR AND B.BUSINESS_UNIT =C.BUSINESS_UNIT AND D.SP_REQ_ID = C.SP_REQ_ID AND D.LINE_NBR =C.SP_LINE_NBR AND D.BUSINESS_UNIT =C.BUSINESS_UNIT AND A.VENDOR_ID =D.VENDOR_ID AND B.SP_REQ_STATUS IN ('C','F','S','P','D')

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