WM_WO_TSK_RMVV1 (SQL View)	Index Back
View removal WO task actions This view will be used for CC actions to identify tasks that have been used for removal

WM_WO_TSK_RMVV1

(SQL View)

View removal WO task actions

This view will be used for CC actions to identify tasks that have been used for removal

SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.TASK_ACTION , A.BUSINESS_UNIT_AM , A.ASSET_ID FROM PS_WM_WO_TSK A WHERE A.TASK_ACTION IN ('4' , '5')

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_WM

3 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

4 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

5 TASK_ACTION Character(1) VARCHAR2(1) NOT NULL The purpose of this field is to identify the kind of action that may be done for a task.
1=No Change
2=Install Component
3=Repair
4=Remove
5=Retire
6=Remove and Sell
7=Replacement asset
8=Ownership Change

6 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

7 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_WM
3	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
4	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
5	TASK_ACTION	Character(1)	VARCHAR2(1) NOT NULL	The purpose of this field is to identify the kind of action that may be done for a task. 1=No Change 2=Install Component 3=Repair 4=Remove 5=Retire 6=Remove and Sell 7=Replacement asset 8=Ownership Change
6	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
7	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification