One pick slip number contains two deliveries.

Hi Team,

we are facing the issue i.e. one pick slip number is having two/three deliveries and among those deliveries one is passing to the API.

API --> wsh_deliveries_pub.delivery_action  

so, one delivery is always pending for ship confirm.

we have modified the Grouping rule and creating delivries with in Order also . see attachments for more details.

Please provide your feedback to get only one delivery for one pick slip number.

 SELECT DISTINCT wnd.delivery_id

                 FROM wsh_delivery_assignments wda,
                      wsh_delivery_details wdd,
                      mtl_txn_request_lines mtrl,
                      mtl_material_transactions mmt
                WHERE wda.delivery_detail_id = wdd.delivery_detail_id