EM_BUVNAGRT2_VW

(SQL View)
 Index Back

BUs that have an agreement


SELECT DISTINCT VE.OPRID , AG.VENDOR_SETID , AG.VENDOR_ID ,BU.BUSINESS_UNIT , BU.DESCR , BU.DESCRSHORT FROM PS_BUS_UNIT_TBL_FS BU , PS_VENDOR_USER VE , PS_SET_CNTRL_REC ST , PS_EM_AGREEMENT AG WHERE BU.BUSINESS_UNIT = ST.SETCNTRLVALUE AND(AG.SETID = ST.SETID OR AG.SETID = ST.SETCNTRLVALUE) AND ST.RECNAME = 'EM_AGREEMENT' AND VE.VENDOR_ID = AG.VENDOR_ID AND AG.EM_AGREE_BUYER = 'Y' AND AG.EM_AGREE_SELLER = 'Y'

  • Related Language Record: EM_BUVNAGRT2_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description