BU_BK_DIST_VW

(SQL View)
 Index Back

Sec Vw - Books by Bus Unit


SELECT A.business_unit , A.book , B.DESCR FROM PS_BU_BOOK_TBL A , PS_BOOK_DEFN_TBL B WHERE b.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC c WHERE c.SETCNTRLVALUE= a.BUSINESS_UNIT AND c.RECNAME='BOOK_DEFN_TBL') AND DISTRIBUTION_SW = 'Y' AND A.BOOK = B.BOOK

  • Related Language Record: BUBK_DIST_LN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description