PO_ITMVNDSET_VW (SQL View)	Index Back
Supplier sets in Item supplier 02/02/01 rml CN#WV802-1.0 Supplier setids in supplier item attributes table

PO_ITMVNDSET_VW

(SQL View)

Supplier sets in Item supplier

02/02/01 rml CN#WV802-1.0 Supplier setids in supplier item attributes table

SELECT DISTINCT VENDOR_SETID , b.DESCR FROM PS_ITM_VND_BU_ATTR a , PS_SETID_TBL b WHERE a.VENDOR_SETID = b.SETID

Related Language Record: PO_ITMVNDSETLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description