diff options
Diffstat (limited to 'calculate_leadtime_po_to_mr.ktr')
| -rw-r--r-- | calculate_leadtime_po_to_mr.ktr | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/calculate_leadtime_po_to_mr.ktr b/calculate_leadtime_po_to_mr.ktr index 282cf26..5067a75 100644 --- a/calculate_leadtime_po_to_mr.ktr +++ b/calculate_leadtime_po_to_mr.ktr @@ -1098,7 +1098,7 @@ else{ <connection>dw bi indoteknik (localhost)</connection> <sql>select po_confirm_date, received_good_date, purchase_line_id, purchase_id, received_id from mv_leadtime_po_to_received ---where purchase_id = 25089 and purchase_line_id = 141455 and received_id in (78477, 78910)</sql> +--where purchase_id = 24864 and purchase_line_id = 140704 and received_id in (76715)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -1263,12 +1263,12 @@ hours AS ( filtered_hours AS ( SELECT ts FROM hours - WHERE - EXTRACT(HOUR FROM ts) BETWEEN 8 AND 17 - AND ( - EXTRACT(HOUR FROM ts) > 8 OR EXTRACT(MINUTE FROM ts) >= 30 - ) - --AND EXTRACT(DOW FROM ts) NOT IN (0) + WHERE 1=1 + --AND EXTRACT(HOUR FROM ts) BETWEEN 8 AND 17 + --AND ( + -- EXTRACT(HOUR FROM ts) > 8 OR EXTRACT(MINUTE FROM ts) >= 30 + --) + AND EXTRACT(DOW FROM ts) NOT IN (0) AND DATE(ts) NOT IN (SELECT holiday_date FROM holidays) ) SELECT COUNT(*) AS new_po_to_arrival, ? as purchase_line_id, ? as purchase_id, ? as received_id |