WM_MY_WO

(SQL View)
Index Back

SELECT C.OPRID , A.PRIORITY_CD ,B.LAST_UPDATE_DTTM ,A.BUSINESS_UNIT ,A.WO_ID ,B.WO_TASK_ID ,B.DESCR254 ,B.STATUS_CD ,B.REQ_START_DT ,B.REQ_START_TIME ,B.SCHEDULER_CODE FROM PS_WM_WO_HDR A , PS_WM_WO_TSK B , PSOPRDEFN C , PS_WM_SCHEDULER_VW D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WO_ID = B.WO_ID AND A.WO_APPROVAL_STATUS='A' AND B.INTERNAL_STATUS <> '06' AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.SHOP_ID = D.SHOP_ID AND B.SCHEDULER_CODE = D.SCHEDULER_CODE AND D.EMPLID = C.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

Prompt Table: WM_PRIORITY

3 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_WM_NONVW

5 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
6 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
8 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

Prompt Table: WM_STATUS_TSK

9 REQ_START_DT Date(10) DATE Required Start
10 REQ_START_TIME Time(15) TIMESTAMP Required Start Time
11 SCHEDULER_CODE Character(10) VARCHAR2(10) NOT NULL Scheduler Code

Prompt Table: WM_SCHEDULER_VW