WM_BU_AM_VW

(SQL View)
 Index Back

AM Business Unit View

This view is used to list all AM Business Units are mapped to the same Maintenance Type as the WM Business Unit is mapped to.

SELECT A.BUSINESS_UNIT ,B.BUSINESS_UNIT ,C.DESCR FROM PS_BUS_UNIT_TBL_WM A ,PS_BUS_UNIT_TBL_AM B ,PS_BUS_UNIT_TBL_FS C WHERE B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.BUSINESS_UNIT IN ( SELECT Y.SETCNTRLVALUE FROM PS_SET_CNTRL_REC X , PS_SET_CNTRL_REC Y WHERE X.SETCNTRLVALUE = A.BUSINESS_UNIT AND X.REC_GROUP_ID = 'AM_13' AND X.RECNAME = 'MAINT_TYPE_TBL' AND Y.SETID = X.SETID AND Y.REC_GROUP_ID = 'AM_13' AND Y.RECNAME = 'MAINT_TYPE_TBL')

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