DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on MTL_SYSTEM_ITEMS

Line 335: from mtl_system_items

331: return;
332: END IF;
333: if p_asset_group_id IS NOT NULL then
334: select location_control_code into l_location_control_code
335: from mtl_system_items
336: where inventory_item_id = p_asset_group_id and
337: organization_id = p_organization_id;
338: end if;
339: select stock_locator_control_code into l_stock_locator_control_code