APPS.WSH_DOCUMENT_PUB dependencies on WSH_DELIVERY_LEGS

Line 228: , wsh_delivery_legs leg

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'
232: AND del.delivery_id = leg.delivery_id

Line 234: AND doc.entity_name = 'WSH_DELIVERY_LEGS'

230: AND det.delivery_detail_id = del.delivery_detail_id
231: and det.container_flag = 'N'
232: AND del.delivery_id = leg.delivery_id
233: AND doc.entity_id = leg.delivery_leg_id
234: AND doc.entity_name = 'WSH_DELIVERY_LEGS'
235: AND nvl(det.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
236: AND doc.status = 'OPEN';
237:
238: l_api_name CONSTANT VARCHAR2(30) := 'Get_Document';