EM_NONREG_BU_V2

(SQL View)
 Index Back

Non-Registerd AP BU's

List of AP BU Descriptions (Names) that are not currently eSettlements buyers.

SELECT B.DESCR , A.BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_AP A , PS_BUS_UNIT_TBL_FS B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND NOT EXISTS ( SELECT C.BUSINESS_UNIT FROM PS_EM_BUY_REG_TBL C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT)

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