Hi,
I need to create a where clause that shows workorders with actuals or any bill approved work that have the flag PLUSPUNBILLEDTRANS ticked.
Unfortunately I can't use this non-persistent field in the where clause
We have attempted the where clause below but would close to show comp and closed workorders.
siteid=(select nvl(defsite,'???') from maxuser where userid= :user)
and istask=0 and historyflag=0 and status in ('COMP') and pluspcustomer is not null
and (ACTMATCOST+ACTLABCOST+ACTTOOLCOST+ACTSERVCOST)>0
and (WORKORDER.siteid, WORKORDER.wonum) not in (
select l.siteid, l.refwo from po p, poline l
where p.siteid=l.siteid and p.ponum=l.ponum and p.revisionnum=l.revisionnum
and p.siteid=(select nvl(defsite,'???') from maxuser where userid= :user)
and p.status in ('WAPPR','INPRG','APPR','PNDREV') and l.refwo is not null)
What where clause is everyone using to show unbilled workorders?
#WorkManagement------------------------------
Steven Allen
John Holland
------------------------------