DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 303: from mtl_secondary_inventories

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

Line 348: from mtl_secondary_inventories

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