EM_BU_AGRT_VW

(SQL View)
 Index Back

BUs that have an agreement


SELECT DISTINCT OPR.OPRID , BU.BUSINESS_UNIT , BU.DESCR , BU.DESCRSHORT FROM PS_BUS_UNIT_TBL_FS BU , PS_SEC_BU_OPR OPR WHERE BU.BUSINESS_UNIT = OPR.BUSINESS_UNIT AND 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_AGRT_LVW

    • # 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description