WM_WO_REPLY_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.WO_ID , A.SEQ_NBR_5 , A.SEQ_NBR_5_LINK , A.TITLE , A.NOTES , A.REPLY_STATUS , A.NOTE_SOURCE , A.VISIBLE_FLG , A.CONTACT_EMPLID , A.CREATED_BY_USER , A.CREATED_DTTM , B.BUSINESS_UNIT_WR , B.WR_ID , B.LEAD_PERSON , B.SUPERVISOR , B.SCHEDULER_CODE FROM PS_WM_WO_NOTES A , PS_WM_WO_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WO_ID = B.WO_ID

# 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 SEQ_NBR_5_LINK Number(5,0) INTEGER NOT NULL Sequence number link
5 TITLE Character(35) VARCHAR2(35) NOT NULL Title
6 NOTES Long Character CLOB Budget Notes
7 REPLY_STATUS Character(1) VARCHAR2(1) NOT NULL Reply Status
0=None
1=Needs Reply
2=Replied
3=Reviewed
4=Canceled
8 NOTE_SOURCE Character(1) VARCHAR2(1) NOT NULL Note Source
0=Service Request
1=Work Order Header
2=3rd Party
3=Other
4=Work Order Task
5=Inspection Activity
9 VISIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Yes/No Indicator
10 CONTACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact Employee ID
11 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
12 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
13 BUSINESS_UNIT_WR Character(5) VARCHAR2(5) NOT NULL Work Request Business Unit
14 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID
15 LEAD_PERSON Character(30) VARCHAR2(30) NOT NULL Lead Person
16 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor
17 SCHEDULER_CODE Character(10) VARCHAR2(10) NOT NULL Scheduler Code