SP_BUARAP_CLSVW

(SQL View)
 Index Back

AR & AP Business Units


SELECT c.oprclass , a.business_unit , a.descr , a.descrshort FROM PS_BUS_UNIT_TBL_FS a , ps_sec_bu_cls c WHERE a.business_unit = c.business_unit AND (EXISTS( SELECT 'x' FROM ps_bu_ar_alt WHERE business_unit = a.business_unit) OR EXISTS( SELECT 'x' FROM ps_bu_ap_alt WHERE business_unit = a.business_unit))

  • Related Language Record: SP_BUARAP_NOLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description