WM_SHOPSCHED_VW

(SQL View)
Index Back

Shop Schedulers


SELECT B.BUSINESS_UNIT , B.SHOP_ID , B.SCHEDULER_CODE , B.EMPLID , C.NAME , B.SHIFT_ID FROM PS_WM_SHOP_SCHED_H A , PS_WM_SHOP_SCHEDLR B , PS_PERSONAL_DATA C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SHOP_ID = B.SHOP_ID AND A.EFFDT = B.EFFDT AND A.EFF_STATUS = 'A' AND B.EMPLID = C.EMPLID AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_WM_SHOP_SCHED_H D WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.SHOP_ID = D.SHOP_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
3 SCHEDULER_CODE Character(10) VARCHAR2(10) NOT NULL Scheduler Code
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: WM_SHOP_RES_VW

5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID

Default Value: WM_SHOP_RES_VW.SHIFT_ID

Prompt Table: WM_SHIFT_VW