DBA Data[Home] [Help]

APPS.WSH_AUTO_MANIFEST dependencies on WSH_TRANSACTIONS_HISTORY

Line 249: FROM wsh_transactions_history wth2

245: AND ((p_client_id IS NULL )
246: OR ( (p_client_id IS NOT NULL) AND (wnd.client_id = p_client_id ))) -- Modified R12.1.1 LSP PROJECT
247: AND NOT EXISTS (
248: SELECT entity_number
249: FROM wsh_transactions_history wth2
250: WHERE wth2.entity_number = wnd.name
251: AND wth2.document_type = 'SA'
252: AND wth2.entity_type = 'DLVY'
253: AND wth2.document_direction = 'O'

Line 264: , wsh_transactions_history wth

260: ,wnd.carrier_id
261: ,wnd.customer_id
262: ,wnd.ultimate_dropoff_location_id ship_to_id
263: FROM wsh_new_deliveries wnd
264: , wsh_transactions_history wth
265: , wsh_delivery_assignments_v wdav
266: , wsh_delivery_details wdd
267: WHERE nvl(wnd.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO')
268: AND wdav.delivery_id = wnd.delivery_id

Line 308: from wsh_transactions_history wth2

304: AND ((p_client_id IS NULL )
305: OR ( (p_client_id IS NOT NULL) AND (wnd.client_id = p_client_id ))) -- Modified R12.1.1 LSP PROJECT
306: AND NOT EXISTS (
307: SELECT entity_number
308: from wsh_transactions_history wth2
309: WHERE wth2.entity_number = wnd.name
310: AND wth2.document_type = 'SA'
311: ) ;
312: