Post

1 follower Follow
0
Avatar

Closed Work Orders without any Employee time entered

This filter finds a list of work orders have no employee time entered.

 

Selected Module:

Work Orders

Filter:

WKORDER LEFT JOIN WKWOTSK ON WKORDER.WO_ID = WKWOTSK.WT_WO_ID LEFT JOIN WKRESRCE ON WKWOTSK.WT_ID = WKRESRCE.WR_WT_ID AND WKRESRCE.WR_RTYP_CD = 1 WHERE WKORDER.WO_STAT_CD  >= 950 AND WKRESRCE.WR_WO_ID IS NULL

Drill Downs:

WKORDER - WO_DEPT_TY

WKORDER - WO_NUMBER

WKWOTSK - WT_TASK_TY

WKRESRCE - WR_RSRC_TY

Jonathan Semones

Please sign in to leave a comment.