APPS.INV_QUANTITY_TREE_UE SQL Statements

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

Line: 356

	 SELECT Primary_Uom_Code
	   INTO l_primary_uom_code
	   FROM MTL_SYSTEM_ITEMS
	   WHERE Organization_Id = p_organization_id
	   AND   Inventory_Item_Id = p_inventory_item_id;

Line: 671

SELECT NVL(lot_control_code, 1)
FROM mtl_system_items
WHERE inventory_item_id = item_id
AND organization_id = org_id;

Line: 946

	  SELECT Primary_Uom_Code
	    INTO l_primary_uom_code
	    FROM MTL_SYSTEM_ITEMS
	    WHERE Organization_Id = p_organization_id
	    AND   Inventory_Item_Id = p_inventory_item_id;

Line: 1383

SELECT NVL(lot_control_code, 1)
FROM mtl_system_items
WHERE inventory_item_id = item_id
AND organization_id = org_id;

Line: 1513

	  SELECT Primary_Uom_Code
	    INTO l_primary_uom_code
	    FROM MTL_SYSTEM_ITEMS
	    WHERE Organization_Id = p_organization_id
	       AND   Inventory_Item_Id = p_inventory_item_id;

Line: 1623

      print_debug('Will call update_qties for xact_mode='||l_xact_mode||', g_qs_txn='||g_qs_txn||', subinv='||p_transfer_subinventory);

Line: 1630

	  print_debug('Calling update_quantities_for_form for xact_mode='||l_xact_mode||', trx_qty='||l_transaction_quantity||', trx_qty2='||p_transaction_quantity2||'.');

Line: 1633

       inv_quantity_tree_pvt.update_quantities_for_form
	 (  p_api_version_number    => 1.0,
	    p_init_msg_lst          => fnd_api.g_true,
	    x_return_status         => l_return_status,
	    x_msg_count             => l_msg_count,
	    x_msg_data              => l_msg_data,
	    p_tree_id               => l_tree_id,
	    p_revision              => p_Revision,
	    p_lot_number            => p_Lot,
	    p_subinventory_code     => p_transfer_Subinventory,
	    p_locator_id            => l_transfer_Locator_id,
	    p_primary_quantity      => l_transaction_quantity,
	    p_secondary_quantity    => p_transaction_quantity2,     -- invConv change
	    p_quantity_type         => inv_quantity_tree_pvt.g_qoh,
	    x_qoh                   => l_qoh,
	    x_rqoh                  => l_rqoh,
	    x_qr                    => l_qr,
	    x_qs                    => l_qs,
	    x_att                   => l_att,
	    x_atr                   => l_atr,
	    x_sqoh                  => l_sqoh,              -- invConv change
	    x_srqoh                 => l_srqoh,             -- invConv change
	    x_sqr                   => l_sqr,               -- invConv change
	    x_sqs                   => l_sqs,               -- invConv change
	    x_satt                  => l_satt,              -- invConv change
	    x_satr                  => l_satr,              -- invConv change
	    p_call_for_form        => fnd_api.g_true,
	    p_lpn_id               =>p_lpn_id            --added for bug7038890
	    );

Line: 1665

	     print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 1');

Line: 1668

	  FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');

Line: 1681

	  print_debug('Calling update_quantities_for_form for trx_qty='||(0 - l_transaction_quantity)||', trx_qty2='||(0 - p_transaction_quantity2)||'.');

Line: 1684

       inv_quantity_tree_pvt.update_quantities_for_form
	 (  p_api_version_number    => 1.0,
	    p_init_msg_lst          => fnd_api.g_true,
	    x_return_status         => l_return_status,
	    x_msg_count             => l_msg_count,
	    x_msg_data              => l_msg_data,
	    p_tree_id               => l_tree_id,
	    p_revision              => p_Revision,
	    p_lot_number            => p_Lot,
	    p_subinventory_code     => p_Subinventory,
	    p_locator_id            => l_Locator_id,
	    p_primary_quantity      => (0 - l_transaction_quantity),
	    p_secondary_quantity    => (0 - p_transaction_quantity2),
	    p_quantity_type         => inv_quantity_tree_pvt.g_qoh,
	    x_qoh                   => l_qoh,
	    x_rqoh                  => l_rqoh,
	    x_qr                    => l_qr,
	    x_qs                    => l_qs,
	    x_att                   => l_att,
	    x_atr                   => l_atr,
	    x_sqoh                  => l_sqoh,                 -- invConv change
	    x_srqoh                 => l_srqoh,                -- invConv change
	    x_sqr                   => l_sqr,                  -- invConv change
	    x_sqs                   => l_sqs,                  -- invConv change
	    x_satt                  => l_satt,                 -- invConv change
	    x_satr                  => l_satr,                 -- invConv change
	    p_call_for_form        => fnd_api.g_true,
	    p_lpn_id               =>p_lpn_id                  --added for bug7038890
	    );

Line: 1716

	     print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 2');

Line: 1719

	  FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');

Line: 1787

	  print_debug('Calling update_quantities_for_form for temp_trx_qty='||l_temp_trx_quantity||', temp_trx_qty2='||l_temp_trx_quantity2||'.');

Line: 1790

       inv_quantity_tree_pvt.update_quantities_for_form
	 (  p_api_version_number    => 1.0,
	    p_init_msg_lst          => fnd_api.g_true,
	    x_return_status         => l_return_status,
	    x_msg_count             => l_msg_count,
	    x_msg_data              => l_msg_data,
	    p_tree_id               => l_tree_id,
	    p_revision              => p_Revision,
	    p_lot_number            => p_Lot,
	    p_subinventory_code     => p_Subinventory,
	    p_locator_id            => l_Locator_id,
	    p_primary_quantity      => l_temp_trx_quantity,
	    p_secondary_quantity    => l_temp_trx_quantity2,      -- invConv change
	    p_quantity_type         => l_xact_mode,
	    x_qoh                   => l_qoh,
	    x_rqoh                  => l_rqoh,
	    x_qr                    => l_qr,
	    x_qs                    => l_qs,
	    x_att                   => l_att,
	    x_atr                   => l_atr,
	    x_sqoh                  => l_sqoh,                    -- invConv change
	    x_srqoh                 => l_srqoh,                   -- invConv change
	    x_sqr                   => l_sqr,                     -- invConv change
	    x_sqs                   => l_sqs,                     -- invConv change
	    x_satt                  => l_satt,                    -- invConv change
	    x_satr                  => l_satr,                    -- invConv change
	    p_call_for_form         => fnd_api.g_true,
	    p_lpn_id                => p_lpn_id                  --added for bug7038890
	    );

Line: 1822

	     print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 3');

Line: 1825

	  FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');