SP_BU_BK2_OPRVW

(SQL View)
 Index Back

Sec Vw - Books by Bus Unit


SELECT D.OPRID , A.BUSINESS_UNIT , A.BOOK , B.DESCR FROM PS_BU_BOOK_TBL A , PS_BOOK_DEFN_TBL B , PS_SEC_BUBOOK_OPR 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 D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.BOOK = A.BOOK

  • Related Language Record: BUBK_DIST_LN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description