WM_WR_REPLY_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.WR_ID , A.SEQ_NBR , A.SEQ_NBR_LINK , A.TITLE , A.NOTES , A.REPLY_STATUS , A.NOTE_SOURCE , A.VISIBLE_FLG , A.CREATED_BY_USER , A.CREATED_DTTM , B.ASSIGNED_TO_OPRID , B.ASSIGNED_BY_OPRID FROM PS_WM_WR_NOTES A , PS_WM_WR_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WR_ID = B.WR_ID

# 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_WR_NONVW

2 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID
3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
4 SEQ_NBR_LINK Number(15,0) DECIMAL(15) 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 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
11 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
12 ASSIGNED_TO_OPRID Character(30) VARCHAR2(30) NOT NULL Assigned To
13 ASSIGNED_BY_OPRID Character(30) VARCHAR2(30) NOT NULL Assigned By