diff options
| -rw-r--r-- | collect_fulfillment_po.ktr | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/collect_fulfillment_po.ktr b/collect_fulfillment_po.ktr index 6683ec9..3f25650 100644 --- a/collect_fulfillment_po.ktr +++ b/collect_fulfillment_po.ktr @@ -534,6 +534,7 @@ from sales_order_fulfillment_v2 where 1=1 and write_date >= (now() - '180 days'::interval) +--and sale_order_line_id in (select id from sale_order_line sol where sol.order_id = 29290) order by sale_order_line_id</sql> <limit>0</limit> <lookup/> @@ -621,6 +622,7 @@ join purchase_order po on po.id = posm.purchase_order_id where 1=1 and po.state in ('purchase', 'done') and posm.write_date >= (now() - '180 days'::interval) +--and posm.sale_line_id in (select id from sale_order_line sol where sol.order_id = 29290) order by posm.sale_line_id</sql> <limit>0</limit> <lookup/> @@ -854,10 +856,16 @@ order by posm.sale_line_id</sql> <condition>=</condition> <name2/> </key> + <key> + <name>purchase_order_id</name> + <field>purchase_order_id</field> + <condition>=</condition> + <name2/> + </key> <value> <name>purchase_order_id</name> <rename>purchase_order_id</rename> - <update>Y</update> + <update>N</update> </value> <value> <name>sales_order_fulfillment_v2_id</name> |