SPF_WO_SRC_RW_V

(SQL View)
Index Back

Work Order Service Table

Work Order Service Table

SELECT A.BUSINESS_UNIT ,A.WORK_ORDER_ID ,A.SEQNBR ,A.SP_REQ_ID ,A.LINE_NBR ,A.ROLE_TYPE ,A.PROJ_ROLE ,B.CONTACT ,B.NOTIFY_BY ,B.VNDR_LOC ,B.VENDOR_ID ,B.ROW_CREATE_DATE ,B.SUBMITAL_NUMBER ,B.VENDOR_SETID ,MAX(SEQUENCE2) FROM PS_SPF_WORDERREC A , PS_SPF_WO_SOURCING B , PS_SPF_WO_SRC_HIST C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID =B.WORK_ORDER_ID AND A.SEQNBR =B.SEQNBR AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.WORK_ORDER_ID =C.WORK_ORDER_ID AND A.SEQNBR =C.SEQNBR AND B.VENDOR_ID =C.VENDOR_ID GROUP BY A.BUSINESS_UNIT ,A.WORK_ORDER_ID ,A.SEQNBR ,A.SP_REQ_ID ,A.LINE_NBR ,A.ROLE_TYPE ,A.PROJ_ROLE ,B.CONTACT ,B.NOTIFY_BY ,B.VNDR_LOC ,B.VENDOR_ID , B.ROW_CREATE_DATE ,B.SUBMITAL_NUMBER ,B.VENDOR_SETID

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_SP_NONVW

2 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID

Default Value: NEXT

3 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number

Default Value: 1

4 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID

Prompt Table: %EDITTABLE9
Set Control Field: BUSINESS_UNIT

5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Prompt Table: %EDITTABLE11

6 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator

Prompt Table: %EDITTABLE33
Set Control Field: BUSINESS_UNIT

7 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

Prompt Table: %EDITTABLE34
Set Control Field: BUSINESS_UNIT

8 CONTACT Character(15) VARCHAR2(15) NOT NULL Provider Contact
9 NOTIFY_BY Character(4) VARCHAR2(4) NOT NULL Notification Method
EM=Email and Worklist
WL=WorkList Only
10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
12 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time
13 SUBMITAL_NUMBER Number(4,0) SMALLINT NOT NULL Number of Times Submitted
14 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
15 SEQUENCE2 Number(6,0) INTEGER NOT NULL Number of Times Sent