APPS.WMS_SHIPPING_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 44

	      SELECT wlpn.outermost_lpn_id,wlpn.organization_id,wda.delivery_detail_id
		FROM wsh_delivery_assignments_v wda ,
		     wsh_delivery_details lpn_wdd ,
			 wms_license_plate_numbers wlpn
		WHERE wda.delivery_id = l_delivery_id
		AND wda.parent_delivery_detail_id=lpn_wdd.delivery_detail_id
		AND wlpn.lpn_id=lpn_wdd.lpn_id;--bug13500119

Line: 54

	  SELECT DISTINCT outermost_lpn_id
	    FROM wms_shipping_transaction_temp
	    WHERE delivery_detail_id = l_delivery_detail_id ;

Line: 94

	          debug('Deleted Delivery : '||l_delivery_id);

Line: 111

			/*13442511 modified the logic to bulk delete.*/
		   IF (l_lpn_id_tab.COUNT > 0 ) THEN
			       FORALL i IN l_lpn_id_tab.first .. l_lpn_id_tab.last
						DELETE FROM wms_dispatched_tasks wdt
                        WHERE task_type = 7
		                AND organization_id = l_org_id_tab(i)
		                AND transfer_lpn_id = l_lpn_id_tab(i);

Line: 120

						DELETE FROM  mtl_material_transactions_temp
                        WHERE wms_task_type = 7
		                AND organization_id = l_org_id_tab(i)
		                AND content_lpn_id = l_lpn_id_tab(i);

Line: 131

		   IF l_debug = 1 THEN debug('Ready to delete  wms_direct_ship_temp '); END IF;

Line: 133

           DELETE FROM wms_direct_ship_temp
            WHERE LPN_ID IN (SELECT DISTINCT  outermost_lpn_id
                                 FROM wms_shipping_transaction_temp
                                 WHERE delivery_id = l_delivery_id);

Line: 148

            IF l_debug = 1 THEN debug('Ready to delete wms_shipping_transaction_temp '); END IF;

Line: 152

		 DELETE FROM wms_shipping_transaction_temp
		 WHERE delivery_detail_id = l_delivery_detail_id_tab(i);

Line: 155

                       debug('Delete wms_shipping_transaction_temp  where delivery_detail_id = ' || l_delivery_detail_id_tab(i));

Line: 163

                       debug('Could not delete wms_shipping_transaction_temp  where delivery_id = ' || l_delivery_id);