WM_WC_PENDWO_VW

(SQL View)
 Index Back

WM Workcenter Pending Wos

WM Workcenter Pending Wos for Approval

SELECT A.BUSINESS_UNIT , A.WO_ID , A.PRIORITY_CD , A.REQ_START_DT , A.SHOP_ID , A.DESCR254 , A.REQ_END_DT , A.WO_SOURCE_CD , A.WO_TYPE , A.BUSINESS_UNIT_WR , A.WR_ID , A.WO_APPROVAL_STATUS , A.BUSINESS_UNIT_PC , A.PROJECT_ID , A.MAINT_TYPE , A.STATUS_CD , A.COMPLTED_DT , A.BUSINESS_UNIT_AM , A.ASSET_ID , G.TAG_NUMBER , G.SERIAL_ID , G.VIN , A.SRVC_GRP_ID , G.ASSET_TYPE , G.ASSET_SUBTYPE , G.ASSET_CRITICALITY , H.LOCATION , H.AREA_ID , A.SCHEDULER_CODE , G.MANUFACTURER , G.MODEL , G.PROD_VERSION FROM PS_WM_WO_HDR A , PS_ASSET G , PS_ASSET_LOCATION H WHERE A.WO_APPROVAL_STATUS IN ('P') AND A.BUSINESS_UNIT_AM = G.BUSINESS_UNIT AND A.ASSET_ID = G.ASSET_ID AND G.BUSINESS_UNIT = H.BUSINESS_UNIT AND G.ASSET_ID = H.ASSET_ID AND H.EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_ASSET_LOCATION I WHERE I.BUSINESS_UNIT = H.BUSINESS_UNIT AND I.ASSET_ID = H.ASSET_ID AND I.EFFDT <= A.REQ_START_DT ) AND H.EFFSEQ = ( SELECT MIN(J.EFFSEQ) FROM PS_ASSET_LOCATION J WHERE J.BUSINESS_UNIT = H.BUSINESS_UNIT AND J.ASSET_ID = H.ASSET_ID AND J.EFFDT = H.EFFDT )

# 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_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

Prompt Table: WM_PRIORITY

4 REQ_START_DT Date(10) DATE Required Start
5 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
7 REQ_END_DT Date(10) DATE Required End
8 WO_SOURCE_CD Character(4) VARCHAR2(4) NOT NULL Work order source code
1=Third Party
2=CRM Help Desk
3=Work Order
4=Service Request
5=Preventive Maintenance
6=Project Costing
7=Express Work Order
8=Condition-based Maintenance
9=WO Inspection

Default Value: 3

9 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type
10 BUSINESS_UNIT_WR Character(5) VARCHAR2(5) NOT NULL Work Request Business Unit

Prompt Table: SP_BU_WR_NONVW

11 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID

Prompt Table: WM_WR_WO_SRCH

12 WO_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
A=Approved
C=Cancelled
E=Denied
I=Initial
P=Pending Approval

Default Value: I

13 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Default Value: BUS_UNIT_TBL_WM.BUSINESS_UNIT_PC

Prompt Table: BUS_UNIT_TBL_PC

14 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: WM_PC_PRJ_DVW

15 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type
16 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

Prompt Table: WM_STATUS_HDR

17 COMPLTED_DT Date(10) DATE Completed Date
18 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
19 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
20 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
21 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
22 VIN Character(18) VARCHAR2(18) NOT NULL VIN
23 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group
24 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
25 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
26 ASSET_CRITICALITY Character(2) VARCHAR2(2) NOT NULL Asset Criticality
27 ASSET_LOCATION Character(10) VARCHAR2(10) NOT NULL Asset Location
28 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID
29 SCHEDULER_CODE Character(10) VARCHAR2(10) NOT NULL Scheduler Code
30 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
31 MODEL Character(30) VARCHAR2(30) NOT NULL Model
32 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version