EM_BUAGR_VW

(SQL View)
 Index Back

MP - Voucher Add View

MP - Voucher Add View

SELECT V.business_unit , FS.DESCR FROM PS_BUS_UNIT_TBL_AP V , PS_INSTALLATION_EM E , PS_BUS_UNIT_tBL_FS FS WHERE V.BUSINESS_UNIT = FS.BUSINESS_UNIT AND (E.EM_MODEL = 'D' OR (E.EM_MODEL = 'P' AND V.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') ))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description