BU_BOOK_LAN_VW5

(SQL View)
 Index Back

Bus. Unit Books w/Dist=Y & Inf


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 a.Book = b.Book AND A.BOOK = D.BOOK AND a.Distribution_Sw='Y' AND a.infl_adj_sw = 'Y'

  • Related Language Record for BU_BOOK_VW5 SP_BOOKB5_CLSVW SP_BOOKB5_NONVW SP_BOOKB5_OPRVW

  • Parent record: BUS_UNIT_TBL_AM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AM_NONVW

    2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

    Prompt Table: SP_BOOK_NONVW

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description