PL_PO_VENDOR_VW

(SQL View)
Index Back

PL_PO_VENDOR_VW

PL_PO_VENDOR_VW

SELECT DISTINCT A.PROBINST , A.VENDOR_ID , B.NAME1 FROM PS_PL_PO_HDR A , PS_VENDOR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID

  • Related Language Record: PL_PO_VENDORLVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1