SP_BU_IUT_NONVW

(SQL View)
 Index Back

IU Pairs view - GL Units

ICE 633962000 - Yang Hsu Assigned record IU_TO_LNVW on Related Language Record.

SELECT A.BUSINESS_UNIT , B.DESCR FROM PS_BUS_UNIT_TBL_GL A , PS_BUS_UNIT_TBL_FS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ELIMS_ONLY = 'N'

  • Related Language Record: IU_TO_LNVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IU_TO_GLBU Character(5) VARCHAR2(5) NOT NULL To GL Business Unit
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description