PV_MS_VENDOR_VW

(SQL View)
 Index Back

Supplier Search Record

10/21/2013 We ensured that the user is unable to add Supplier Location which is already in use by another Linked Suppler Type.Modified VNDR_LOC Prompt value.

SELECT A.PV_MS_SUP_TYPE , A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.PV_MS_SUP_MPID , B.NAME1 , A.PV_MS_SUP_TP_SNAME FROM PS_PV_MS_SUPPLIER A , PS_VENDOR B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PV_MS_SUP_TYPE Character(1) VARCHAR2(1) NOT NULL Linked Supplier Type
1=MarketPlace Supplier
2=Cohera Supplier
3=Catalog Management Supplier
4=Direct Connect Supplier
5=Oracle Network Supplier
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETVC_NONVW

3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: PV_MS_VNDR_VW

4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: PV_CP_VNDR_L_VW

5 PV_MS_SUP_MPID Character(50) VARCHAR2(50) NOT NULL e
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
7 PV_MS_SUP_TP_SNAME Character(25) VARCHAR2(25) NOT NULL Supplier TP Short Name