PI_BU_LOC_LG_VW

(SQL View)
 Index Back

AT - Scan Location BUs

All Business Units for a Location (Scan Location).

SELECT DISTINCT A.LOCATION , C.SETCNTRLVALUE , A.LANGUAGE_CD , B.DESCR FROM PS_LOCATION_LANG A , PS_SET_CNTRL_REC C , PS_BUS_UNIT_TBL_FS B WHERE A.SETID = C.SETID AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND C.RECNAME = 'LOCATION_TBL'

  • Related Language Record for PI_BU_LOC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OVERWRITE_LOCATION Character(10) VARCHAR2(10) NOT NULL Scan Location
    2 BUSINESS_UNIT_1 Character(5) VARCHAR2(5) NOT NULL Non-Joint Venture BU
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description