--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->
 Limit  (cost=9708.14..9761.39 rows=100 width=22666)
   ->  Result  (cost=9708.14..10065.44 rows=671 width=22666)
         ->  Sort  (cost=9708.14..9709.81 rows=671 width=22635)
               Sort Key: order2_.dateordered, orderline0_.c_orderline_id
               ->  Hash Join  (cost=31.30..9682.49 rows=671 width=22635)
                     Hash Cond: ((orderline0_.c_uom_id)::text = (uom9_.c_uom_id)::text)
                     ->  Nested Loop  (cost=19.95..9669.26 rows=671 width=21305)
                           ->  Hash Join  (cost=19.66..8953.09 rows=671 width=16039)
                                 Hash Cond: ((orderline0_.m_warehouse_id)::text = (warehouse7_.m_warehouse_id)::text)
                                 ->  Hash Join  (cost=8.76..8940.24 rows=671 width=14127)
                                       Hash Cond: ((orderline0_.c_bpartner_id)::text = (businesspa3_.c_bpartner_id)::text)
                                       ->  Nested Loop  (cost=0.69..8930.34 rows=671 width=10790)
                                             Join Filter: ((orderline0_.ad_org_id)::text = (organizati1_.ad_org_id)::text)
                                             ->  Nested Loop  (cost=0.69..8898.12 rows=671 width=4678)
                                                   ->  Nested Loop  (cost=0.41..5560.76 rows=1093 width=253)
                                                         ->  Seq Scan on c_orderline orderline0_  (cost=0.00..2330.25 rows=3279 width=220)
                                                               Filter: (((ad_client_id)::text = ANY ('{0,A64C68776B544B0DB59C16456C43E608}'::text[])) AND ((ad_org_id)::text = ANY ('{0,BF67B59606F643E08CCC51A1CD93ECD5,E70BD74CE0E4432D9A8B22C43B12CD4C,097E2B5F86394085B84832391860905E,B9BA55A1633440C4B8BAB5A66A569A10,F477B20FCDEB46D897DC5B361B92D95F,3FF21930C89F4A8FAC60E7264BF96568582D874E69DE476B967E943E8C5DCA5A}'::text[])))
                                                         ->  Index Only Scan using c_orderline_key on c_orderline orderline_6_  (cost=0.41..0.99 rows=1 width=33)
                                                               Index Cond: (c_orderline_id = (orderline0_.c_orderline_id)::text)
                                                               Filter: ((SubPlan 3) > '0'::numeric)
                                                               SubPlan 3
                                                                 ->  Result  (cost=0.00..0.26 rows=1 width=32)
                                                   ->  Index Scan using c_order_key on c_order order2_  (cost=0.28..3.05 rows=1 width=4425)
                                                         Index Cond: ((c_order_id)::text = (orderline0_.c_order_id)::text)
                                                         Filter: ((issotrx = 'Y'::bpchar) AND ((docstatus)::text = 'CO'::text))
                                             ->  Materialize  (cost=0.00..3.04 rows=3 width=6112)
                                                   ->  Seq Scan on ad_org organizati1_  (cost=0.00..3.03 rows=3 width=6112)
                                       ->  Hash  (cost=6.92..6.92 rows=92 width=3337)
                                             ->  Seq Scan on c_bpartner businesspa3_  (cost=0.00..6.92 rows=92 width=3337)
                                 ->  Hash  (cost=10.40..10.40 rows=40 width=1912)
                                       ->  Seq Scan on m_warehouse warehouse7_  (cost=0.00..10.40 rows=40 width=1912)
                           ->  Index Scan using m_product_key on m_product product8_  (cost=0.28..1.07 rows=1 width=5266)
                                 Index Cond: ((m_product_id)::text = (orderline0_.m_product_id)::text)
                     ->  Hash  (cost=10.60..10.60 rows=60 width=1310)
                           ->  Seq Scan on c_uom uom9_  (cost=0.00..10.60 rows=60 width=1310)
         SubPlan 1
           ->  Result  (cost=0.00..0.26 rows=1 width=32)
         SubPlan 2
           ->  Result  (cost=0.00..0.26 rows=1 width=32)
(39 rows)