WM_PCVLDSGRP_VW

(SQL View)
 Index Back

View for Valid Service Groups

This view gives a list of valid Service Groups for a given project and WOBU combination

SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , B.SRVC_GRP_ID , B.DESCR FROM PS_WM_PC_DFLT_DTL A , PS_WM_SRVC_GRP B WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_WM_PC_DFLT_DTL A1 WHERE A.BUSINESS_UNIT = A1.BUSINESS_UNIT AND A.WO_TYPE = A1.WO_TYPE AND A.SRVC_GRP_ID = A1.SRVC_GRP_ID ) AND ( A.SRVC_GRP_ID = B.SRVC_GRP_ID OR A.SRVC_GRP_ID = '%') AND EXISTS ( SELECT 'x' FROM PS_SET_CNTRL_REC D WHERE D.RECNAME = 'WM_SRVC_GRP' AND A.BUSINESS_UNIT = D.SETCNTRLVALUE)

# 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 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description