APPS.INV_TRANSACTION_HIDDEN SQL Statements

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

Line: 124

SELECT stock_locator_control_code INTO l_org_level
FROM mtl_parameters WHERE organization_id = p_Organization_Id;

Line: 127

SELECT locator_type INTO l_sub_level
FROM mtl_secondary_inventories WHERE organization_id = p_Organization_Id
AND secondary_inventory_name = p_Subinventory_Code;

Line: 277

	select location_control_code into l_Location_Control_Code from
	mtl_system_items where
	inventory_item_id = p_Inventory_Item_Id and
	organization_id = l_org;