PO_ITMVNDITS_VW

(SQL View)
 Index Back

Item Setids in ITM_VND_BU_ATTR

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

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

  • Related Language Record: PO_ITMVNDITSLVW

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