WM_PC_WCRD_VW

(SQL View)
Index Back

View by WO type and Service

The purpose of this view is to provide a distinct list of Projects based on a work order type and service group combination. The default project table is based on wildcarding. This record joins to the WO type table to get a full view.

SELECT DISTINCT A.BUSINESS_UNIT , A.WO_TYPE , A.SRVC_GRP_ID , A.PROJECT_ID , F.DESCR FROM PS_WM_PC_DFLT_DTL A , PS_PROJECT F WHERE (A.WO_TYPE = '%' OR A.SRVC_GRP_ID = '%') AND A.BUSINESS_UNIT_PC = F.BUSINESS_UNIT AND A.PROJECT_ID = F.PROJECT_ID AND F.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_WM_NONVW

2 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type
3 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group
4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description