EG_SS_ECOVND_VW

(SQL View)
 Index Back

Supplier List by ECOs

Created on 04/09/00 RML View to show suppliers by ECO 06/06/00 ST Added rel lang vw

SELECT DISTINCT a.BUSINESS_UNIT , a.ECO_ID , a.VENDOR_SETID , a.VENDOR_ID , b.NAME1 , a.INV_ITEM_ID_LAST FROM PS_EG_IC_ECOHDR_VW a , PS_VENDOR b WHERE a.VENDOR_SETID = b.SETID AND a.VENDOR_ID = b.VENDOR_ID

  • Related Language Record: EG_SS_ECOVN_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ECO_ID Character(10) VARCHAR2(10) NOT NULL ECO Number
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID