APPS.INV_MO_ADMIN_PUB SQL Statements

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

Line: 105

      Update MTL_TXN_REQUEST_HEADERS
      set    header_status = 6,
      last_updated_by = fnd_global.user_id,
      last_update_login = fnd_global.login_id,
      last_update_date = sysdate
      where
             header_id = l_header_id;

Line: 191

		SELECT header_status, request_number
    INTO   l_hdr_status, l_request_number
		FROM   mtl_txn_request_headers
		WHERE  Header_id = l_header_id;

Line: 211

          SELECT 1
          INTO   l_line_status
          FROM   mtl_txn_request_lines
          WHERE  header_id = l_header_id
          AND    line_status in (1,2,8)
          AND    ROWNUM = 1;

Line: 250

      Update MTL_TXN_REQUEST_HEADERS
      set    header_status = 5,
      last_updated_by = fnd_global.user_id,
      last_update_login = fnd_global.login_id,
      last_update_date = sysdate
      where
             header_id = l_header_id;

Line: 334

		Select header_status, request_number
                into   l_hdr_status, l_request_number
		from mtl_txn_request_headers
		where
                Header_id = l_header_id;

Line: 357

      Delete MTL_TXN_REQUEST_LINES
      where
             header_id = l_header_id;

Line: 361

      Delete MTL_TXN_REQUEST_HEADERS
      where
             header_id = l_header_id;

Line: 442

  l_delete_mmtt	        Varchar2(3); --Added bug 3524130

Line: 466

		SELECT line_status, quantity_delivered, move_order_type, organization_id
    INTO   l_line_status, l_qty_del, l_mo_type, l_org_id
		FROM   mtl_txn_request_lines_v
		WHERE  Line_Id = l_Line_Id
    FOR UPDATE NOWAIT;

Line: 515

      select  1
      into l_loaded_lpn_exists
      from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt
      where mmtt.transaction_temp_id = wdt.transaction_temp_id
      and wdt.status = 4
      and mmtt.transfer_lpn_id is not null
      and mmtt.move_order_line_id = l_line_id
      and rownum = 1;

Line: 527

	l_delete_mmtt := 'NO';

Line: 531

	l_delete_mmtt := 'YES';

Line: 538

	  l_delete_mmtt := 'YES';

Line: 550

       l_delete_mmtt := 'YES';

Line: 554

      l_new_trolin_tbl(1).operation   := INV_GLOBALS.G_OPR_UPDATE;

Line: 556

     /** call update line API **/
   INV_Transfer_Order_PVT.Process_Transfer_Order
        (  p_api_version_number       => 1.0 ,
           p_init_msg_list            => FND_API.G_TRUE,
           x_return_status            => l_return_status,
           x_msg_count                => l_msg_count,
           x_msg_data                 => l_msg_data,
           p_trolin_tbl               => l_new_trolin_tbl,
           p_old_trolin_tbl           => l_old_trolin_tbl,
           x_trohdr_rec               => l_x_trohdr_rec,
           x_trolin_tbl               => l_x_trolin_tbl,
	   p_delete_mmtt	      => l_delete_mmtt  --Added bug3524130
        );

Line: 663

		SELECT line_status, quantity_delivered, quantity ,organization_id
    INTO   l_line_status, l_qty_del, l_qty, l_org_id
		FROM   mtl_txn_request_lines
		WHERE  Line_Id = l_Line_Id
    FOR UPDATE NOWAIT;

Line: 713

	    SELECT 1 INTO l_wrd_exists FROM dual WHERE exists
	      (SELECT 1
	       FROM wms_replenishment_details wrd
	       WHERE wrd.source_line_id = l_line_id);

Line: 728

	    select  1
	      into l_loaded_lpn_exists
	      from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt
	      where mmtt.transaction_temp_id = wdt.transaction_temp_id
	      and wdt.status = 4
	      and mmtt.transfer_lpn_id is not null
		and mmtt.move_order_line_id = l_line_id
		and rownum = 1;

Line: 747

	Update MTL_TXN_REQUEST_LINES
	set    line_status = 9,
	last_updated_by = fnd_global.user_id,
	last_update_login = fnd_global.login_id,
	last_update_date = sysdate,
        status_date = SYSDATE --bug 5053725
	where line_id = l_line_id;

Line: 757

          Delete MTL_MATERIAL_TRANSACTIONS_TEMP
          Where
                 Move_Order_Line_Id = l_line_id;

Line: 769

       Update MTL_TXN_REQUEST_LINES
       set    line_status = 5,
       last_updated_by = fnd_global.user_id,
       last_update_login = fnd_global.login_id,
       last_update_date = sysdate,
       status_date = SYSDATE --bug 5053725
       where
             line_id = l_line_id;