[Home] [Help]
2902: -- WORKITEM
2903:
2904: SELECT count(*)
2905: INTO v_cnt
2906: FROM xdp_workitems_vl wi
2907: WHERE NOT EXISTS
2908: (SELECT 1
2909: FROM wf_lookups wl
2910: WHERE substr(wl.lookup_code,1,29) = substr(wi.workitem_name,1, 29)