WM_VWPM_EXCP_VW

(SQL View)
Index Back

PM Exception view


SELECT DISTINCT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.SCHEDULER_CODE , B.EMPLID , A.WM_PM_EXCEP_TYPE FROM PS_WM_PM_EXCEPTION A , PS_WM_SHOPSCHED_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SHOP_ID = B.SHOP_ID AND A.SCHEDULER_CODE = B.SCHEDULER_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT

Prompt Table: SP_BU_WM_NONVW

3 SCHEDULER_CODE Character(10) VARCHAR2(10) NOT NULL Scheduler Code
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 WM_PM_EXCEP_TYPE Character(1) VARCHAR2(1) NOT NULL PM exception type
1=PM Linking
2=Auto Assignment and Dispatch