WM_WOTYPCLS_VW (SQL View)	Index Back
Close days by BU and nospecify List of all business units and wo types where close days is not specified

WM_WOTYPCLS_VW

(SQL View)

Close days by BU and nospecify

List of all business units and wo types where close days is not specified

SELECT A.BUSINESS_UNIT , B.WO_TYPE , B.CLOSE_DAYS_TSK FROM PS_WM_WO_TYPE B , PS_BUS_UNIT_TBL_WM A WHERE B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC SET1 WHERE SET1.SETID = B.SETID AND SET1.RECNAME = 'WM_WO_TYPE' AND SET1.SETCNTRLVALUE = A.BUSINESS_UNIT) AND B.CLOSE_DAYS_TSK_DEF = 'S'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_WM

2 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

3 CLOSE_DAYS_TSK Signed Number(6,0) DECIMAL(5) NOT NULL Number of close days for WO Task

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_WM
2	WO_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Work Order Type
3	CLOSE_DAYS_TSK	Signed Number(6,0)	DECIMAL(5) NOT NULL	Number of close days for WO Task