WM_SRVC_GRP_WBU

(SQL View)
Index Back

Work Order Service Group

Work Order Service Group Definition Table

SELECT DISTINCT C.BUSINESS_UNIT , A.SRVC_GRP_ID , A.DESCR , A.DESCRSHORT FROM PS_WM_SRVC_GRP A , PS_SET_CNTRL_GROUP B , PS_WM_SHOP_SRVCGRP C , PS_WM_SHOP_HDR D WHERE D.BUSINESS_UNIT = B.SETCNTRLVALUE AND B.REC_GROUP_ID = 'WM_02' AND A.SETID = B.SETID AND A.SRVC_GRP_ID = C.SRVC_GRP_ID AND D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.SHOP_ID = C.SHOP_ID AND %EffdtCheck(WM_SHOP_HDR E, D, %CurrentDateIn) AND D.EFF_STATUS = 'A'

  • Related Language Record: WM_SVCGP_WBU_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
    2 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description