BUBK_DIST_LN_VW

(SQL View)
 Index Back

Sec Vw - Books by Bus Unit


SELECT A.business_unit , A.book , D.language_cd , D.DESCR FROM PS_BU_BOOK_TBL A , PS_BOOK_DEFN_TBL B , PS_BOOK_DEFN_LANG D 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 AND A.BOOK = D.BOOK

  • Related Language Record for BU_BK_DIST_VW BU_BK_DST_NONVW SP_BU_BK2_CLSVW SP_BU_BK2_NONVW SP_BU_BK2_OPRVW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description