APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 301: from mtl_secondary_inventories

297: return;
298: else
299: -- check for expense inventory
300: select asset_inventory into l_asset_inventory
301: from mtl_secondary_inventories
302: where secondary_inventory_name = p_inventory_item_info(1).subinventory
303: and organization_id = p_organization_id;
304: IF (NOT l_asset_inventory = 2) THEN
305: FND_MESSAGE.set_name('EAM', 'EAM_EXPENSE_SUBINVENTORY');

Line 346: from mtl_secondary_inventories

342: for i in 1..p_inventory_item_info.COUNT loop
343: l_locator := p_inventory_item_info(i).locator;
344: l_subinventory := p_inventory_item_info(i).subinventory;
345: select locator_type into l_locator_type
346: from mtl_secondary_inventories
347: where secondary_inventory_name = l_subinventory
348: and organization_id = p_organization_id;
349:
350: if (l_location_control_code in (2,3) or l_locator_type in (2,3)