PO_ITMVNDSETLVW (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_ITMVNDSETLVW

(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 , lng.LANGUAGE_CD , lng.DESCR FROM PS_ITM_VND_BU_ATTR a , PS_SETID_LANG lng WHERE a.VENDOR_SETID = lng.SETID

Related Language Record for PO_ITMVNDSET_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description