SP_BU_BK2_NONVW

(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