WM_PROB_SHOP_VW

(SQL View)
 Index Back

Problem Shop Location View


SELECT DISTINCT A.SETID , A.TREE_NODE , A.LOCATION_SETID , A.WR_LOCATION , A.SRVC_GRP_ID , A.BUSINESS_UNIT_WO , B.SHOP_ID , B.DESCR , B.LOCATION , B.CITY , B.COUNTY , B.STATE , B.POSTAL , B.COUNTRY , B.BUILDING , B.FLOOR , B.SECTOR , A.AGENT_ROLE , A.TECHNICIAN_ROLE , A.WO_TYPE , A.PRIORITY_CD FROM PS_WM_PROBLEM_LOC A , PS_WM_SHOP_LOC_VW B WHERE A.SRVC_GRP_ID = B.SRVC_GRP_ID AND A.BUSINESS_UNIT_WO = B.BUSINESS_UNIT

  • Related Language Record: WM_PROB_SHP_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    3 LOCATION_SETID Character(5) VARCHAR2(5) NOT NULL Location Set ID
    4 WR_LOCATION Character(10) VARCHAR2(10) NOT NULL Service Location
    5 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group
    6 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
    7 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    10 CITY Character(30) VARCHAR2(30) NOT NULL City
    11 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    12 STATE Character(6) VARCHAR2(6) NOT NULL State
    13 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    15 BUILDING Character(10) VARCHAR2(10) NOT NULL Building #
    16 FLOOR Character(10) VARCHAR2(10) NOT NULL Floor #
    17 SECTOR Character(10) VARCHAR2(10) NOT NULL Sector
    18 AGENT_ROLE Character(30) VARCHAR2(30) NOT NULL Agent role name
    19 TECHNICIAN_ROLE Character(30) VARCHAR2(30) NOT NULL Technician role name
    20 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type
    21 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code