Date Initials Reference # Description 08/28/2008 Jer 1770532004 Corrected the Supplier Lookup Prompt to display all Supplier for Express Catalog Source.

PV_LWC_VNDR_VW

(SQL View)
Index Back

SELECT DISTINCT B.SETID , B.VENDOR_ID , B.VNDR_LOC FROM PS_EOCM_GEN_TBL A , PS_PV_MS_SUPPLIER B WHERE A.SETID = B.SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location