BUS_UNIT_VA_VW

(SQL View)
 Index Back

VAT Apportionment BU


select distinct e.setid, a.business_unit, a.descr from ps_bus_unit_tbl_fs a, ps_set_cntrl_rec e where (exists (select business_unit from ps_bus_unit_tbl_pm b where a.business_unit = b.business_unit) or exists (select business_unit from ps_bus_unit_tbl_ap c where a.business_unit = c.business_unit) or exists (select business_unit_gl from PS_BUS_UNIT_TBL_EX d where a.business_unit = d.business_unit_gl)) and a.business_unit = e.setcntrlvalue and e.recname = 'VAT_APORT_VALUE'

  • Related Language Record: BUS_UNIT_VA_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description