RS_BUEX_SRCH

(SQL View)
 Index Back

EX Business Units Search View

Returns Expenses Business Units that have not yet been linked to a Region in Utilization Percentage setup.

SELECT A.BUSINESS_UNIT , B.DESCR FROM %Table(BUS_UNIT_TBL_GL) A , %Table(BUS_UNIT_TBL_FS) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT NOT IN ( SELECT DISTINCT BUSINESS_UNIT FROM %Table(RS_REGION_BUEX))

  • Related Language Record: RS_BUEX_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_GL_NONVW

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