APPS.EAM_ASSETNUMBER_PUB dependencies on MTL_PARAMETERS

Line 172: -- Validate the serial uniqueness specified in the MTL Parameters

168: add_error('EAM_ASSET_NUMBER_EXISTS');
169: RAISE FND_API.G_EXC_ERROR;
170: end if;
171:
172: -- Validate the serial uniqueness specified in the MTL Parameters
173: eam_asset_number_pvt.serial_check(
174: p_api_version => 1.0,
175: x_return_status => l_return_status,
176: x_msg_count => errCount,

Line 875: FROM csi_item_instances cii, mtl_parameters mp

871:
872: BEGIN
873: SELECT cii.instance_id, nvl(cii.maintainable_flag, 'Y'), nvl(cii.network_asset_flag, 'N'), mp.maint_organization_id
874: INTO l_instance_id, l_old_maint_flag, l_old_network_asset_flag, l_org
875: FROM csi_item_instances cii, mtl_parameters mp
876: WHERE cii.serial_number = p_serial_number
877: AND cii.inventory_item_id = p_inventory_item_id
878: AND cii.last_vld_organization_id = p_current_organization_id
879: AND cii.last_vld_organization_id = mp.organization_id;

Line 1147: from mtl_parameters

1143: end if;
1144:
1145: if (not (p_current_organization_id = l_prod_organization_id)) then
1146: select count(*) into l_count
1147: from mtl_parameters
1148: where organization_id=l_prod_organization_id
1149: and maint_organization_id=p_current_organization_id;
1150:
1151: if (l_count=0) then