|
SELECT DISTINCT A.BUSINESS_UNIT , A.CM_BOOK FROM PS_CM_NP_TRAN_VW A UNION SELECT DISTINCT B.BUSINESS_UNIT , B.CM_BOOK FROM PS_CM_NP_INTRAN_VW B UNION SELECT DISTINCT C.BUSINESS_UNIT , C.CM_BOOK FROM PS_CM_NP_CMTRN_VW C UNION SELECT DISTINCT D.BUSINESS_UNIT , D.CM_BOOK FROM PS_CM_NP_REC_VW D UNION SELECT DISTINCT E.BUSINESS_UNIT , E.CM_BOOK FROM PS_CM_NP_DEPN_VW E UNION SELECT DISTINCT F.BUSINESS_UNIT , F.CM_BOOK FROM PS_CM_NP_DEP_VW F UNION SELECT DISTINCT G.BUSINESS_UNIT , G.CM_BOOK FROM PS_CM_NP_TVAR_VW G UNION SELECT DISTINCT H.BUSINESS_UNIT , H.CM_BOOK FROM PS_CM_NP_SHIPB_VW H UNION SELECT DISTINCT I.BUSINESS_UNIT , I.CM_BOOK FROM PS_CM_NP_RTOKIT_VW I UNION SELECT DISTINCT J.BUSINESS_UNIT , J.CM_BOOK FROM PS_CM_NP_VAR_VW J UNION SELECT DISTINCT K.BUSINESS_UNIT , K.CM_BOOK FROM PS_CM_NP_MATCH_VW K UNION SELECT DISTINCT L.BUSINESS_UNIT , L.CM_BOOK FROM PS_CM_NP_RMATCH_VW L UNION SELECT DISTINCT M.BUSINESS_UNIT , M.CM_BOOK FROM PS_CM_NP_MATCHB_VW M UNION SELECT DISTINCT N.BUSINESS_UNIT , N.CM_BOOK FROM PS_CM_NP_DEPN1_VW N UNION SELECT DISTINCT O.BUSINESS_UNIT , O.CM_BOOK FROM PS_CM_NP_USRADJ_VW O UNION SELECT DISTINCT P.BUSINESS_UNIT , P.CM_BOOK FROM PS_CM_NP_TRAN1_VW P UNION SELECT DISTINCT Q.BUSINESS_UNIT , Q.CM_BOOK FROM PS_CM_NP_EARN1_VW Q UNION SELECT DISTINCT R.BUSINESS_UNIT , R.CM_BOOK FROM PS_CM_NP_EARN2_VW R UNION SELECT DISTINCT S.BUSINESS_UNIT , S.CM_BOOK FROM PS_CM_NP_DVAR_VW S
|