EM_BU_VNAGRT_VW

(SQL View)
 Index Back

BUs that have an agreement


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

  • Related Language Record: EM_BU_VNAGR_LNG

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