PO_ITMVNDITM_VW

(SQL View)
 Index Back

Sup Items in ITM_VND_BU_ATTR

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

SELECT DISTINCT a.INV_ITEM_ID , b.DESCR FROM PS_ITM_VND_BU_ATTR a , PS_ITM_PURCH_VW b WHERE a.SETID = b.SETID AND a.INV_ITEM_ID = b.INV_ITEM_ID

  • Related Language Record: PO_ITMVNDITMLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description