SPF_SPC_REQ_VW

(SQL View)
Index Back

Wo - Relealted Requisition

Wo - Related Requisition view

SELECT DISTINCT B.BUSINESS_UNIT , B.VENDOR_ID , A.REQ_ID , B.SP_REQ_ID FROM PS_PV_REQ_LN_XREF A , PS_SPF_SOURCING B WHERE A.SP_BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SP_REQ_ID = B.SP_REQ_ID AND A.SP_LINE_NBR =B.LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
4 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID