SPF_SPC_SSRWO_V

(SQL View)
 Index Back

Sourcing Provider contact vw


SELECT DISTINCT BUSINESS_UNIT ,SP_REQ_ID ,LINE_NBR ,WORK_ORDER_ID , VENDOR_ID ,VNDR_LOC ,SERVICE_METHOD ,CONTACT , SPC_OWNER ,SOURCE_DATE ,SUBMITAL_LIMIT ,SUBMITAL_NUMBER ,VENDOR_SETID ,RECRUITER ,PROJECT_ID , PROJ_ROLE ,ROW_CREATE_USER , SP_NUM_OF_POSITION ,MAX(SEQUENCE2) FROM PS_SPF_SPC_SRWO_VW GROUP BY BUSINESS_UNIT ,SP_REQ_ID , LINE_NBR ,WORK_ORDER_ID , VENDOR_ID , VNDR_LOC ,SERVICE_METHOD ,CONTACT ,SPC_OWNER , SUBMITAL_LIMIT , SUBMITAL_NUMBER ,SOURCE_DATE , VENDOR_SETID , RECRUITER , PROJECT_ID , PROJ_ROLE ,SP_NUM_OF_POSITION , ROW_CREATE_USER ,ROW_CREATE_USER

# 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 BID_SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
P=Replacement
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