BU_LEASE_BK_VW

(SQL View)
 Index Back

Business Unit Lease Book View


SELECT a.BUSINESS_UNIT , a.LEASE_BOOK , b.SETID , b.LC_CNTRY FROM PS_BUS_UNIT_TBL_AM a , ps_Book_Defn_Tbl b WHERE b.SetID = ( SELECT c.SetID FROM ps_Set_Cntrl_Rec c WHERE c.SetCntrlValue= a.Business_Unit AND c.RecName='BOOK_DEFN_TBL') AND a.LEASE_Book = b.Book

  • 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 LC_CNTRY Character(3) VARCHAR2(3) NOT NULL The local country.