SP_BUINT_NONVW

(SQL View)
Index Back

Business Unit Subsystem


select distinct a.business_unit, c.descr from ps_bus_unit_tbl_gl a, PS_BU_LED_GRP_TBL b, ps_bus_unit_tbl_fs c where a.business_unit = b.business_unit and a.business_unit = c.business_unit and b.ledger_type = 'D'

  • Related Language Record: SP_BUINT_N_LANG
  • # 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

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description