EG_SSVNDITM_VW

(SQL View)
Index Back

eProd Mgmt - Supplier Item vie

Created on 09/30/00 rml Clone of mg_item_vw with join to supplier security record "en_ic_bom_priv"

SELECT b.setid , b.vendor_id , a.business_unit , a.inv_item_id , a.descr FROM ps_mg_item_vw a , PS_EN_IC_BOM_PRIV b WHERE a.business_unit = b.business_unit AND a.inv_item_id = b.inv_item_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description