DBA Data[Home] [Help]

APPS.WSH_AUTO_MANIFEST dependencies on WSH_TRANSACTIONS_HISTORY

Line 190: , wsh_transactions_history wth

186: ,wnd.carrier_id
187: ,wnd.customer_id
188: ,wnd.ultimate_dropoff_location_id ship_to_id
189: FROM wsh_new_deliveries wnd
190: , wsh_transactions_history wth
191: , wsh_delivery_assignments_v wdav
192: , wsh_delivery_details wdd
193: WHERE nvl(wnd.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO')
194: AND wdav.delivery_id = wnd.delivery_id

Line 223: from wsh_transactions_history wth2

219: AND wth.document_type = 'SR'
220: AND wth.entity_type = 'DLVY'
221: AND NOT EXISTS (
222: SELECT entity_number
223: from wsh_transactions_history wth2
224: WHERE wth2.entity_number = wnd.name
225: AND wth2.document_type = 'SA'
226: ) ;
227: