Pour Time Variance Actual vs. Target

Query:

select t.cust_no "Cust" ,t.job_po_loc "Job",t.ticket_no "Ticket",T.TRUCK_NO "Truck",
   tgt_begin_pour_dt,tgt_end_pour_dt,
   floor( .5+  (tgt_end_pour_dt-tgt_begin_pour_dt)*1440) "Tgt Pour Min",  
   begin_pour_dt,end_pour_dt, floor (.5+  (end_pour_dt-begin_pour_dt   )*1440) "Act Pour Min",
   floor (.5 +   ((end_pour_dt-begin_pour_dt   )- (tgt_end_pour_dt-tgt_begin_pour_dt) )  *1440) "Minutes Over"
,l.load_size from artptkhd t
inner join ditprjld l on t.order_session_no=l.order_session_no and t.order_trans_no=l.order_trans_no and l.load_no=t.order_load_no
where status_col>6 and t.void_flag<>'Y'   and floor (.5 +   ((end_pour_dt-begin_pour_dt   )- (tgt_end_pour_dt-tgt_begin_pour_dt) )  *1440) not between -10 and 10
and t.ticket_date=:Report_Date
order by t.cust_no,t.job_po_loc

Field Break/Group Cust - 1/1 Job - 2/2

Format DateTimes as hh:mm Format Elapsed times as ##0

See Also: Time Queries for Tickets and Sales History