WM_WO_TSK_RMVVW

(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

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.WO_ID , A.WO_TASK_ID , A.DESCR254 , B.PROFILE_ID , A.TASK_ACTION , A.BUSINESS_UNIT_AM , B.COMPONENT_OF_ID , B.SERIAL_ID , B.TAG_NUMBER , B.VIN , A.WO_ID FROM PS_WM_WO_TSK A , PS_ASSET B WHERE A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND A.TASK_ACTION IN ('4', '5') AND A.INTERNAL_STATUS NOT IN ('05', '06', '07') AND B.COMPONENT_OF_ID <> ' ' AND NOT EXISTS ( SELECT 'X' FROM PS_WM_WO_TSK_CC X WHERE X.BUSINESS_UNIT_WO = A.BUSINESS_UNIT AND X.WO_ID_ASSOC = A.WO_ID AND X.WO_TASK_ID_TO = A.WO_TASK_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset
3 WO_ID_ASSOC Character(10) VARCHAR2(10) NOT NULL Work Order ID
4 WO_TASK_ID_TO Number(5,0) INTEGER NOT NULL Removal Task Information
5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
6 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
7 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
8 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
9 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
10 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
11 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
12 VIN Character(18) VARCHAR2(18) NOT NULL VIN
13 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification