APPS.WMS_SHIPPING_PUB SQL Statements

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

Line: 37

	  SELECT delivery_detail_id
	    FROM wsh_delivery_assignments_v
	    WHERE delivery_id = l_delivery_id;

Line: 42

	  SELECT DISTINCT outermost_lpn_id
	    FROM wms_shipping_transaction_temp
	    WHERE delivery_detail_id = l_delivery_detail_id ;

Line: 76

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

Line: 98

                SELECT organization_id
                INTO l_organization_id
                FROM wsh_delivery_details
                WHERE delivery_detail_id = l_delivery_detail_id;

Line: 110

	         DELETE FROM wms_dispatched_tasks wdt
		   WHERE task_type = 7
		   AND organization_id = l_organization_id
		   AND transfer_lpn_id IN
		  (SELECT wlpn.outermost_lpn_id
		    FROM wms_license_plate_numbers wlpn,
		         wsh_delivery_details wdd,
		         wsh_delivery_assignments_v wda
		    WHERE wda.delivery_detail_id = l_delivery_detail_id
		    AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
		    AND wdd.lpn_id = wlpn.lpn_id);

Line: 121

                 IF l_debug = 1 THEN debug('Deleted Staging move WDTs ' || l_delivery_detail_id); END IF;

Line: 128

	         DELETE FROM mtl_material_transactions_temp
		   WHERE wms_task_type = 7
		   AND organization_id = l_organization_id
		   AND content_lpn_id IN
		  ( SELECT wlpn.outermost_lpn_id
		    FROM wms_license_plate_numbers wlpn,
		         wsh_delivery_details wdd,
		         wsh_delivery_assignments_v wda
		    WHERE wda.delivery_detail_id = l_delivery_detail_id
		    AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
		    AND wdd.lpn_id = wlpn.lpn_id);

Line: 139

                  IF l_debug = 1 THEN debug('Deleted Staging move MMTT ' || l_delivery_detail_id); END IF;

Line: 155

	      -- get lpn_ids to update the context
	   /*   Mrana: MDC & LPN Convergence : The following updates should not be necessary
 *            OPEN get_lpn_id(l_delivery_detail_id);

Line: 161

		 -- update lpns with context of picked

                 IF l_debug = 1 THEN debug('Ready to update wms_license_plate_numbers '); END IF;

Line: 166

		 UPDATE wms_license_plate_numbers
		   SET lpn_context = 11,
		   last_update_date = Sysdate,
		   last_updated_by = fnd_global.user_id
		   WHERE lpn_id IN (SELECT lpn_id
				    FROM wms_license_plate_numbers
				    START WITH lpn_id = l_outermost_lpn_id
				    CONNECT BY parent_lpn_id = PRIOR lpn_id);

Line: 176

                    debug('Updated wms_license_plate_numbers : ' || l_outermost_lpn_id);

Line: 197

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

Line: 199

                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: 214

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

Line: 215

                 DELETE FROM wms_shipping_transaction_temp
                 WHERE delivery_id = l_delivery_id ;

Line: 223

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