142: , doc.attribute15
143: FROM
144: wsh_document_instances doc
145: , wsh_delivery_details det
146: , wsh_delivery_assignments_v del
147: WHERE det.source_line_id = p_order_line_id
148: AND det.delivery_detail_id = del.delivery_detail_id
149: and det.container_flag = 'N'
150: AND doc.entity_id = del.delivery_id
223: , doc.attribute15
224: FROM
225: wsh_document_instances doc
226: , wsh_delivery_details det
227: , wsh_delivery_assignments_v del
228: , wsh_delivery_legs leg
229: WHERE det.source_line_id = p_order_line_id
230: AND det.delivery_detail_id = del.delivery_detail_id
231: and det.container_flag = 'N'