APPS.WMS_ATF_UTIL_APIS SQL Statements

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

Line: 193

	    SELECT
	      transaction_temp_id,
	      transaction_action_id,
	      transaction_source_type_id,
	      parent_line_id,
	      rcv_transaction_id
	      FROM mtl_material_transactions_temp
	      WHERE transaction_header_id = p_txn_header_id
	      AND Nvl(transaction_batch_id, -999) = Nvl(p_txn_batch_id,  Nvl(transaction_batch_id, -999))
--	      AND transaction_temp_id = Nvl(p_transaction_temp_id, transaction_temp_id
	      AND wms_task_type IN (2, -1) -- putaway
	      ;

Line: 211

	    SELECT
	      transaction_temp_id,
	      transaction_action_id,
	      transaction_source_type_id,
	      parent_line_id,
	      rcv_transaction_id
	      FROM mtl_material_transactions_temp
--	      WHERE transaction_header_id = p_txn_header_id
--	      AND Nvl(transaction_batch_id, -999) = Nvl(p_txn_batch_id, Nvl(transaction_batch_id, -999))
	      WHERE transaction_temp_id = p_transaction_temp_id
	      AND wms_task_type IN (2, -1) -- putaway
	      ;

Line: 228

	    SELECT routing_header_id,user_entered_flag
	      FROM rcv_transactions
	      WHERE transaction_id = v_rt_transaction_id;

Line: 238

	    SELECT lpn_id, content_lpn_id, transfer_lpn_id
	      FROM mtl_material_transactions_temp
	      WHERE transaction_temp_id = p_transaction_temp_id
	      AND (wms_task_type NOT IN (2, -1)
		   OR wms_task_type IS NULL);

Line: 247

	     SELECT transaction_temp_id
	       FROM mtl_material_transactions_temp
	       WHERE lpn_id = v_lpn_id
	       AND operation_plan_id IS NOT NULL
		 AND wms_task_type IN (2, -1);

Line: 493

	     SELECT 1
	       INTO l_wdt_exists
	       FROM DUAL
	       WHERE EXISTS(SELECT 1
                      FROM wms_dispatched_tasks
			    WHERE task_type=2
			    AND (transaction_temp_id = l_txn_batch_inbound_mmtt_rec.transaction_temp_id
				 OR transaction_temp_id =
				 l_txn_batch_inbound_mmtt_rec.parent_line_id));