SP_BU_OM2_NONVW

(SQL View)
Index Back

Sec Vw - PS/OM Active BUs


SELECT a.business_unit , b.descr , b.descr FROM ps_bus_unit_tbl_om a , PS_BUS_UNIT_TBL_FS b WHERE a.business_unit = b.business_unit AND a.bu_status_om = 'A'

  • Related Language Record: SP_BUOMNVW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field