Prompt record to show contract id's for Supplier PO Search page.

PO_SSCNTRCT_VW

(SQL View)
 Index Back

SELECT DISTINCT A.VENDOR_SETID , A.VENDOR_ID , B.CNTRCT_ID FROM PS_PO_HDR A , PS_PO_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND B.CNTRCT_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID