WM_AMDWNTIME_VW

(SQL View)
 Index Back

WO Downtime Search Record

Downtime Task for Work orders

SELECT B.BUSINESS_UNIT , B.ASSET_ID , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.ASSET_CRITICALITY , B. TAG_NUMBER , B.VIN , B.SERIAL_ID , B.MFG_ID , B.MODEL , LOC.LOCATION , LOC.AREA_ID , B.CREW_ID FROM PS_ASSET B , PS_ASSET_LOC_VW LOC WHERE B.BUSINESS_UNIT = LOC.BUSINESS_UNIT AND B.ASSET_ID = LOC.ASSET_ID AND EXISTS ( SELECT 'X' FROM PS_WM_WO_DWNTME DWN , PS_WM_WO_TSK A WHERE DWN.BUSINESS_UNIT = A.BUSINESS_UNIT AND DWN.WO_ID = A.WO_ID AND DWN.WO_TASK_ID = A.WO_TASK_ID AND A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID )

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

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT

Prompt Table: SP_BU_AM_NONVW

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

Prompt Table: ASSET

3 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
4 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

Prompt Table: AM_SUBTYPE
Set Control Field: BUSINESS_UNIT

5 ASSET_CRITICALITY Character(2) VARCHAR2(2) NOT NULL Asset Criticality

Prompt Table: AM_CRIT_LVL
Set Control Field: BUSINESS_UNIT

6 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
7 VIN Character(18) VARCHAR2(18) NOT NULL VIN
8 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
9 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER
Set Control Field: BUSINESS_UNIT

10 MODEL Character(30) VARCHAR2(30) NOT NULL Model

Prompt Table: MFG_MODEL
Set Control Field: BUSINESS_UNIT

11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL
Set Control Field: BUSINESS_UNIT

12 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: AM_AREA_TBL
Set Control Field: BUSINESS_UNIT

13 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name