WM_PROB_SHP_LVW

(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 , C.LANGUAGE_CD , 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 , PS_WM_SHOP_LOC_LG C WHERE A.SRVC_GRP_ID = B.SRVC_GRP_ID AND A.BUSINESS_UNIT_WO = B.BUSINESS_UNIT AND B.SRVC_GRP_ID = C.SRVC_GRP_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.SHOP_ID = C.SHOP_ID

  • Related Language Record for WM_PROB_SHOP_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    11 CITY Character(30) VARCHAR2(30) NOT NULL City
    12 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    13 STATE Character(6) VARCHAR2(6) NOT NULL State
    14 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    16 BUILDING Character(10) VARCHAR2(10) NOT NULL Building #
    17 FLOOR Character(10) VARCHAR2(10) NOT NULL Floor #
    18 SECTOR Character(10) VARCHAR2(10) NOT NULL Sector
    19 AGENT_ROLE Character(30) VARCHAR2(30) NOT NULL Agent role name
    20 TECHNICIAN_ROLE Character(30) VARCHAR2(30) NOT NULL Technician role name
    21 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type
    22 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code