http://in.compucrete.com/index.php?action=history&feed=atom&title=Dispatch_Time_Diagnostics 2026-05-15T17:03:53Z Revision history for this page on the wiki MediaWiki 1.40.0 http://in.compucrete.com/index.php?title=Dispatch_Time_Diagnostics&diff=186&oldid=prev 2023-07-14T12:58:49Z

<p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td> </tr> <!-- diff cache key my_wiki:diff::1.12:old-185:rev-186 --> </table>

WikiAdmin http://in.compucrete.com/index.php?title=Dispatch_Time_Diagnostics&diff=185&oldid=prev 2017-01-10T00:01:39Z

<p>1 revision imported</p> <p><b>New page</b></p><div>==Return Time Diagnostics==<br /> &lt;PRE&gt;<br /> select t.ticket_no,T.TRUCK_NO,tgt_leave_job_dt,leave_job_dt,<br /> (leave_job_dt-tgt_leave_job_dt)*1440 &quot;Late Mins&quot;,<br /> tgt_return_offset, tgt_return_plant_dt,<br /> tgt_return_plant_dt+(leave_job_dt- tgt_leave_job_dt) &quot;Projected Return DT&quot;,cast('now' as timestamp) &quot;Now&quot;,<br /> (tgt_return_plant_dt+(leave_job_dt-tgt_leave_job_dt)-cast('now' as timestamp))*1440 &quot;Min to Go&quot; , t.void_flag<br /> from artptkhd t<br /> inner join ditprjld l on t.order_session_no=l.order_session_no<br /> and t.order_trans_no=l.order_trans_no and l.load_no=t.order_load_no<br /> where status_col=7 and t.void_flag&lt;&gt;'Y'<br /> &lt;/PRE&gt;</div>

Intra>User