WM_WO_RLYCT_VW(SQL View) |
Index Back |
|---|
| SELECT B.BUSINESS_UNIT , B.WO_ID , B.SEQ_NBR_5 , B.REPLY_STATUS , A.WO_SOURCE_CD FROM PS_WM_WO_HDR A , PS_WM_WO_NOTES B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WO_ID = B.WO_ID AND A.WO_SOURCE_CD IN ('1','2','3','4') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 3 | SEQ_NBR_5 | Number(5,0) | INTEGER NOT NULL | Sequence number five digits long |
| 4 | REPLY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Reply Status
0=None 1=Needs Reply 2=Replied 3=Reviewed 4=Canceled |
| 5 | 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 |