PO_ITMVNDITMLVW

(SQL View)
 Index Back

Sup Items in ITM_VND_BU_ATTR

02/02/01 rml CN#WV802-1.0 Related language view for po_itmvnditm_vw. Supplier items in supplier item attributes table

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

  • Related Language Record for PO_ITMVNDITM_VW

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