WM_PC_VLDTYP_VW

(SQL View)
 Index Back

View for Valid WO types

This view gives a list of valid WO types for a given project and WOBU combination

SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , B.WO_TYPE , B.DESCR FROM PS_WM_PC_DFLT_DTL A , PS_WM_WO_TYPE 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.WO_TYPE = B.WO_TYPE OR A.WO_TYPE = '%') AND EXISTS ( SELECT 'x' FROM PS_SET_CNTRL_REC D WHERE D.RECNAME = 'WM_WO_TYPE' 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 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description