PI_BU_LOC_VW

(SQL View)
 Index Back

AT - Scan Location BUs

All Business Units for a Location (Scan Location).

SELECT DISTINCT A.LOCATION , C.SETCNTRLVALUE , B.DESCR FROM PS_LOCATION_TBL 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: PI_BU_LOC_LG_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description